<cfsetting requesttimeout="600" showdebugoutput="no">
<cfscript>
base = new assets.calgrants.com.Base();
currentProgramYear = base.getCurrentProgramYear();
</cfscript>
<cfparam name="Program_Year" type="string" default="#currentProgramYear#" />
<cfparam name="Workshop_ID" type="numeric" default="0" />
<cfparam name="Organizer_ID" type="numeric" default="0" />
<cfparam name="Manager_ID" type="numeric" default="0" />
<cfparam name="Site_ID" type="numeric" default="0" />
<cfparam name="Organization_ID" type="numeric" default="0" />
<cfparam name="Zip_Code_ID" type="string" default="0" />
<cfparam name="City_ID" type="string" default="0" />
<cfparam name="County_ID" type="numeric" default="0" />
<cfparam name="Region_ID" type="numeric" default="0" />
<cfparam name="School_District_ID" type="numeric" default="0" />
<cfparam name="School_ID" type="numeric" default="0" />
<cfparam name="State_Legislative_District_ID" type="numeric" default="0" />
<cfscript>
	workshopGateway = new assets.calgrants.com.gateway.WorkshopGateway();
	siteGateway = new assets.calgrants.com.gateway.SiteGateway();
	organizationGateway = new assets.calgrants.com.gateway.OrganizationGateway();
	countyGateway = new assets.calgrants.com.gateway.CountyGateway();
	evaluationGateway = new assets.calgrants.com.gateway.EvaluationGateway();
	storedProcedureGateway = new assets.calgrants.com.gateway.StoredProcedureGateway();
	colors = ["##2682d6","##5dba5d","##0f2a88","##55b4d0","##417630","##aad9e7","##444444","##ccc","##2682d6","##5dba5d","##0f2a88","##55b4d0","##417630","##aad9e7","##444444","##ccc"];
	questions = "1,6,7,10,11,12";
	currentData = StructNew();
	genderData = StructNew();
	raceData = StructNew();
	raceGenderData = StructNew();
	calGrantData = StructNew();
	gdsData = StructNew();
	trendData = StructNew();
	if (Workshop_ID gt 0) {
		qWorkshop = workshopGateway.query(Workshop_ID = Workshop_ID);
		qSite = siteGateway.query(Site_ID = qWorkshop.Site_ID);
		qOrganization = organizationGateway.query(Organization_ID = qSite.Organization_ID);
		qCounty = countyGateway.query(County_ID = qSite.County_ID);
		currentEvaluations = evaluationGateway.report(workshopIDs = Workshop_ID, excludeOtherResponses = true);
		gdsGateway = new assets.calgrants.com.gateway.GDSGateway();
		gds = gdsGateway.query(workshopIDs = Workshop_ID);
		trendWorkshops = workshopGateway.query(Site_ID = qWorkshop.Site_ID, Deleted = 0, Approved = 1);
		site = qSite.Site;
		workshopDate = qWorkshop.Workshop_Date;
		organization = qOrganization.Organization;
		city = qSite.City;
		county = qCounty.County;
		region = qCounty.Region;
		siteType = qSite.Site_Type;
		siteSince = qSite.Initial_Program_Year;
		computerBasedWorkshop = qWorkshop.Online;
		organizationSince = qOrganization.Initial_Program_Year;
		scholarshipAwarded = true;
		followUpRequests = qWorkshop.Follow_Up_Request_Count;
		followUpRequestsPct = qWorkshop.Follow_Up_Request_Count / qWorkshop.Student_Count * 100;
		followedUp = qWorkshop.Complete_Follow_Up_Request_Count;
		scholarshipCounts = storedProcedureGateway.getScholarshipCounts(Program_Year = qWorkshop.Program_Year, Workshop_ID = Workshop_ID);
		rollupLevel = "workshop";
		oID = Workshop_ID;
		Program_Year = qWorkshop.Program_Year;
	} else if (Organizer_ID gt 0) {
		// not implemented
		rollupLevel = "organizer";
		oID = Organizer_ID;
	} else if (Manager_ID gt 0) {
		// not implemented
		rollupLevel = "manager";
		oID = Manager_ID;
	} else if (Site_ID gt 0) {
		qSite = siteGateway.query(Site_ID = Site_ID);
		qOrganization = organizationGateway.query(Organization_ID = qSite.Organization_ID);
		qCounty = countyGateway.query(County_ID = qSite.County_ID);
		currentEvaluations = evaluationGateway.report(programYears = Program_Year, siteIDs = Site_ID, excludeOtherResponses = true);
		gdsGateway = new assets.calgrants.com.gateway.GDSGateway();
		gds = gdsGateway.query(programYears = Program_Year, siteIDs = Site_ID);
		trendWorkshops = workshopGateway.query(Site_ID = Site_ID, Deleted = 0, Approved = 1);
		site = qSite.Site;
		organization = qOrganization.Organization;
		city = qSite.City;
		county = qCounty.County;
		region = qCounty.Region;
		siteType = qSite.Site_Type;
		siteSince = qSite.Initial_Program_Year;
		organizationSince = qOrganization.Initial_Program_Year;
		scholarshipCounts = storedProcedureGateway.getScholarshipCounts(Program_Year = Program_Year, Site_ID = Site_ID);
		rollupLevel = "site";
		oID = Site_ID;
	} else if (Organization_ID gt 0) {
		qOrganization = organizationGateway.query(Organization_ID = Organization_ID);
		qCounty = countyGateway.query(County_ID = qOrganization.County_ID);
		currentEvaluations = evaluationGateway.report(programYears = Program_Year, organizationIDs = Organization_ID, excludeOtherResponses = true);
		gdsGateway = new assets.calgrants.com.gateway.GDSGateway();
		gds = gdsGateway.query(programYears = Program_Year, organizationIDs = Organization_ID);
		trendWorkshops = workshopGateway.query(organizationIDs = Organization_ID, Deleted = 0, Approved = 1);
		organization = qOrganization.Organization;
		county = qCounty.County;
		region = qCounty.Region;
		organizationSince = qOrganization.Initial_Program_Year;
		scholarshipCounts = storedProcedureGateway.getScholarshipCounts(Program_Year = Program_Year, Organization_ID = Organization_ID);
		rollupLevel = "organization";
		oID = Organization_ID;
	} else if (Zip_Code_ID gt 0) {
		// not implemented
		rollupLevel = "zipCode";
		oID = Zip_Code_ID;
	} else if (City_ID gt 0) {
		// not implemented
		rollupLevel = "city";
		oID = City_ID;
	} else if (County_ID gt 0) {
		qCounty = countyGateway.query(County_ID);
		currentEvaluations = evaluationGateway.report(programYears = Program_Year, countyIDs = County_ID, excludeOtherResponses = true);
		gdsGateway = new assets.calgrants.com.gateway.GDSGateway();
		gds = gdsGateway.query(programYears = Program_Year, countyIDs = County_ID);
		trendWorkshops = workshopGateway.query(countyIDs = County_ID, Deleted = 0, Approved = 1);
		county = qCounty.County;
		region = qCounty.Region;
		scholarshipCounts = storedProcedureGateway.getScholarshipCounts(Program_Year = Program_Year, County_ID = County_ID);	
		rollupLevel = "county";
		oID = County_ID;
	} else if (Region_ID gt 0) {
		qCounty = countyGateway.query(Region_ID = Region_ID);
		currentEvaluations = evaluationGateway.report(programYears = Program_Year, regionIDs = Region_ID, excludeOtherResponses = true);
		gdsGateway = new assets.calgrants.com.gateway.GDSGateway();
		gds = gdsGateway.query(programYears = Program_Year, regionIDs = Region_ID);
		trendWorkshops = workshopGateway.query(regionIDs = Region_ID, Deleted = 0, Approved = 1);
		region = qCounty.Region;
		scholarshipCounts = storedProcedureGateway.getScholarshipCounts(Program_Year = Program_Year, Region_ID = Region_ID);
		rollupLevel = "region";
		oID = Region_ID;
	} else if (School_District_ID gt 0) {
		// not implemented
		rollupLevel = "schoolDistrict";
		oID = School_District_ID;
	} else if (School_ID gt 0) {
		// not implemented
		rollupLevel = "school";
		oID = School_ID;
	} else if (State_Legislative_District_ID gt 0) {
		// not implemented
		rollupLevel = "stateLegislativeDistrict";
		oID = State_Legislative_District_ID;
	} else { // statewide
		currentEvaluations = evaluationGateway.report(programYears = Program_Year, excludeOtherResponses = true);
		gdsGateway = new assets.calgrants.com.gateway.GDSGateway();
		gds = gdsGateway.query(programYears = Program_Year);
		trendWorkshops = workshopGateway.query(Deleted = 0, Approved = 1);
		scholarshipCounts = storedProcedureGateway.getScholarshipCounts(Program_Year = Program_Year);
		rollupLevel = "statewide";
		oID = 0;
	}
	baseResponses = currentEvaluations[1].response_count + currentEvaluations[1].no_response_count;
	seniorBaseResponses = currentEvaluations[1].senior_response_count + currentEvaluations[1].senior_no_response_count;
	if (baseResponses gt 0) {
		seniorBaseResponsePercent = seniorBaseResponses/baseResponses*100;
	} else {
		seniorBaseResponsePercent = 0;
	};
	gdsMatchCount = gds.RecordCount;
	if (baseResponses gt 0) {
		gdsMatchPercent = gdsMatchCount/baseResponses*100;
	} else {
		gdsMatchPercent = 0;
	};
</cfscript>

<!--- need to cache queries, especially trend data --->

<!--- build currentData from currentEvaluations --->
<cfloop index="q" list="#questions#">
	<cfset currentData[q] = StructCopy(currentEvaluations[q]) />
	<cfloop index="a" from="1" to="#ArrayLen(currentData[q].Answers)#">
		<!--- remove open-ended responses to reduce struct size --->
		<cfset StructDelete(currentData[q].Answers[a], "Answer_Values") />
	</cfloop>
</cfloop>

<!--- build race x gender data --->
<cfset raceGenderData = StructNew() />
<cfset raceGenderData["aaMales"] = 0 />
<cfset raceGenderData["hispanicMales"] = 0 />

<!--- build trend data --->
<cfquery name="getProgramYears" dbtype="query">
	select	sum(Student_Count) as studentCount,
			count(distinct Workshop_ID) as workshopCount,
			count(distinct Site_ID) as siteCount,
			count(distinct Manager_ID) as managerCount,
			count(distinct Organizer_ID) as organizerCount,
			count(distinct Organization_ID) as organizationCount,
			count(distinct City) as cityCount,
			count(distinct Zip_Code) as zipCodeCount,
			count(distinct County) as countyCount,
			count(distinct Region_ID) as regionCount,
			Program_Year 
	from 	trendWorkshops 
	group by Program_Year 
	having 	Program_Year > <cfqueryparam cfsqltype="cf_sql_varchar" value="2010-2011" null="no" /> 
	and 	Program_Year <= <cfqueryparam cfsqltype="cf_sql_varchar" value="#Program_Year#" null="no" /> 
	and 	studentCount >= <cfqueryparam cfsqltype="cf_sql_integer" value="1" null="no" />
</cfquery>
<cfset programYears = ValueList(getProgramYears.Program_Year) />
<cfloop query="getProgramYears">
	<cfif Workshop_ID gt 0 or Site_ID gt 0>
		<cfset trend = evaluationGateway.report(siteIDs = qSite.Site_ID, programYears = getProgramYears.Program_Year) />
	<cfelseif Organization_ID gt 0>
		<cfset trend = evaluationGateway.report(organizationIDs = Organization_ID, programYears = getProgramYears.Program_Year) />
	<cfelseif County_ID gt 0>
		<cfset trend = evaluationGateway.report(countyIDs = County_ID, programYears = getProgramYears.Program_Year) />
	<cfelseif Region_ID gt 0>
		<cfset trend = evaluationGateway.report(regionIDs = Region_ID, programYears = getProgramYears.Program_Year) />
	<cfelse>
		<cfset trend = evaluationGateway.report(programYears = getProgramYears.Program_Year) />
	</cfif>
	<cfif NOT StructKeyExists(trendData, "Program_Year_Stats")>
		<cfset trendData["PROGRAM_YEAR_STATS"] = StructNew() />
	</cfif>
	<cfset pyData = StructNew() />
	<cfset pyData["STUDENT_COUNT"] = getProgramYears.studentCount />
	<cfset pyData["SITE_COUNT"] = getProgramYears.siteCount />
	<cfset pyData["MANAGER_COUNT"] = getProgramYears.managerCount />
	<cfset pyData["ORGANIZER_COUNT"] = getProgramYears.organizerCount />
	<cfset pyData["ORGANIZATION_COUNT"] = getProgramYears.organizationCount />
	<cfset pyData["CITY_COUNT"] = getProgramYears.cityCount />
	<cfset pyData["ZIP_CODE_COUNT"] = getProgramYears.zipCodeCount />
	<cfset pyData["COUNTY_COUNT"] = getProgramYears.countyCount />
	<cfset pyData["REGION_COUNT"] = getProgramYears.regionCount />
	<cfset trendData["PROGRAM_YEAR_STATS"][getProgramYears.Program_Year] = pyData />
	<cfloop index="q" list="#questions#">
		<cfif NOT StructKeyExists(trendData, q)>
			<cfset trendData[q] = StructCopy(trend[q])>
			<cfset StructDelete(trendData[q], "Answers") />
			<cfset trendData[q]["ANSWERS"] = StructNew() />
		</cfif>
		<cfloop index="a" from="1" to="#ArrayLen(trend[q].Answers)#">
			<cfif trend[q].Answers[a].Answer_Active eq 1>
				<cfset n = trend[q].Answers[a].Answer_Number />
				<cfif q neq "11" or n neq "3">
					<cfif NOT StructKeyExists(trendData[q]["ANSWERS"], n)>
						<cfset trendData[q]["ANSWERS"][n] = ArrayNew(1) />
					</cfif>
					<cfset dataSet = StructCopy(trend[q].Answers[a]) />
					<cfset StructDelete(dataSet, "ANSWER_VALUES") />
					<cfset dataSet["PROGRAM_YEAR"] = getProgramYears.Program_Year />
					<cfset ArrayAppend(trendData[q]["ANSWERS"][n], dataSet) />
				</cfif>
			</cfif>
		</cfloop>
	</cfloop>
</cfloop>

<!--- build gender data --->
<cfset genderAnswers = currentData["11"].Answers />
<cfset genderData["totalCount"] = 0 />
<cfset genderData["maleFemaleCount"] = 0 />
<cfloop index="a" from="1" to="#ArrayLen(genderAnswers)#">
	<cfif genderAnswers[a].Answer neq "Decline to answer">
		<cfset genderData[LCase(genderAnswers[a].Answer) & "Count"] = genderAnswers[a].Response_Count>
		<cfset genderData[LCase(genderAnswers[a].Answer) & "Percent"] = genderAnswers[a].Response_Percent>
	<cfelse>
		<cfset genderData["declineToAnswerCount"] = genderAnswers[a].Response_Count>
		<cfset genderData["declineToAnswerPercent"] = genderAnswers[a].Response_Percent>
	</cfif>
	<cfset genderData["totalCount"] = genderData["totalCount"] + genderAnswers[a].Response_Count />
</cfloop>
<cfset genderData["maleFemaleCount"] = genderData["maleCount"] + genderData["femaleCount"] />
<cfset genderData["femaleOnCount"] = Int(genderData.femalePercent/10) />
<cfset genderData["femaleOffCount"] = 10 - genderData["femaleOnCount"] />
<cfset genderData["femaleCountLeadingCols"] = genderData["femaleOnCount"] - 1 />
<cfset genderData["femaleCountTrailingCols"] = 9 - genderData["femaleCountLeadingCols"] />
<cfset genderData["maleOnCount"] = Int(genderData.malePercent/10) />
<cfset genderData["maleOffCount"] = 10 - genderData["maleOnCount"] />
<cfset genderData["maleCountLeadingCols"] = genderData["maleOnCount"] - 1 />
<cfif genderData["maleCountLeadingCols"] gt 1>
	<cfset genderData["maleCountTrailingCols"] = 8 - genderData["maleCountLeadingCols"] />
<cfelse>
	<cfset genderData["maleCountTrailingCols"] = 8 />
</cfif>

<!--- build race/ethnicity data --->
<cfset raceAnswers = currentData["12"].Answers />
<cfset raceData["totalCount"] = 0 />
<cfloop index="a" from="1" to="#ArrayLen(raceAnswers)#">
	<cfif raceAnswers[a].Answer neq "Decline to answer">
		<cfset raceData[LCase(raceAnswers[a].Answer) & "Count"] = raceAnswers[a].Response_Count>
		<cfset raceData[LCase(raceAnswers[a].Answer) & "Percent"] = raceAnswers[a].Response_Percent>
	<cfelse>
		<cfset raceData["declineToAnswerCount"] = raceAnswers[a].Response_Count>
		<cfset raceData["declineToAnswerPercent"] = raceAnswers[a].Response_Percent>
	</cfif>
	<cfset raceData["totalCount"] = raceData["totalCount"] + raceAnswers[a].Response_Count />
</cfloop>

<!--- build GDS data --->
<cfset gdsData["totalCount"] = 0 />
<cfset gdsData["seniorCount"] = 0 />
<cfset gdsData["fafsaSubmitted"] = 0 />
<cfset gdsData["dreamersSubmitted"] = 0 />
<cfset gdsData["fafsaCompleted"] = 0 />
<cfset gdsData["dreamersCompleted"] = 0 />
<cfset gdsData["fafsaCompletedPercent"] = 0 />
<cfset gdsData["fafsaOnTime"] = 0 />
<cfset gdsData["dreamersOnTime"] = 0 />
<cfset gdsData["fafsaOnTimeCompleted"] = 0 />
<cfset gdsData["dreamersOnTimeCompleted"] = 0 />
<cfset gdsData["fafsaPellEligible"] = 0 />
<cfset gdsData["fafsaDollarsAwarded"] = 0 />
<cfset gdsData["calgrantSubmitted"] = 0 />
<cfset gdsData["calgrantCompleted"] = 0 />
<cfset gdsData["calgrantCompletedPercent"] = 0 />
<cfset gdsData["calgrantAwarded"] = 0 />
<cfset gdsData["calgrantAAwarded"] = 0 />
<cfset gdsData["calgrantBAwarded"] = 0 />
<cfset gdsData["calgrantCAwarded"] = 0 />
<cfset gdsData["calgrantAwardedPercent"] = 0 />
<cfset gdsData["calgrantAAwardedPercent"] = 0 />
<cfset gdsData["calgrantBAwardedPercent"] = 0 />
<cfset gdsData["calgrantCAwardedPercent"] = 0 />
<cfset gdsData["calgrantDollarsAwarded"] = 0 />
<cfset gdsData["calgrantADollarsAwarded"] = 0 />
<cfset gdsData["calgrantBDollarsAwarded"] = 0 />
<cfset gdsData["calgrantCDollarsAwarded"] = 0 />

<cfloop query="gds">
	<cfset gdsData["totalCount"] = gdsData["totalCount"] + 1 />
	<!--- submitted = SSN value --->
	<cfif Len(SSN) gt 0>
		<cfif Left(SSN, 4) eq "0000" or On_Time_Dream_Act_Cal_ISIR eq "Y">
			<cfset isDreamer = true />
		<cfelse>
			<cfset isDreamer = false />
		</cfif>
		<cfset gdsData["fafsaSubmitted"] = gdsData["fafsaSubmitted"] + 1 />
		<cfif isDreamer>
			<cfset gdsData["dreamersSubmitted"] = gdsData["dreamersSubmitted"] + 1 />
		</cfif>
		<cfif On_Time_ISIR eq "Y" or On_Time_Dream_Act_Cal_ISIR eq "Y">
			<cfset gdsData["fafsaOnTime"] = gdsData["fafsaOnTime"] + 1 />
		</cfif>
		<cfif On_Time_Dream_Act_Cal_ISIR eq "Y">
			<cfset gdsData["dreamersOnTime"] = gdsData["dreamersOnTime"] + 1 />
		</cfif>	
		<!--- fafsa/dream act completed --->
		<cfif Len(Trim(Primary_EFC)) gt 0>
			<cfset gdsData["fafsaCompleted"] = gdsData["fafsaCompleted"] + 1 />
			<cfif isDreamer>
				<cfset gdsData["dreamersCompleted"] = gdsData["dreamersCompleted"] + 1 />
			</cfif>
			<cfif On_Time_ISIR eq "Y" or On_Time_Dream_Act_Cal_ISIR eq "Y">
				<cfset gdsData["fafsaOnTimeCompleted"] = gdsData["fafsaOnTimeCompleted"] + 1 />
			</cfif>
			<cfif On_Time_Dream_Act_Cal_ISIR eq "Y">
				<cfset gdsData["dreamersOnTimeCompleted"] = gdsData["dreamersOnTimeCompleted"] + 1 />
			</cfif>			
			<cfif Pell_Grant_Elig_Flag eq "Y">
				<cfset gdsData["fafsaPellEligible"] = gdsData["fafsaPellEligible"] + 1 />
				<cfif Program_Year eq "2013-2014">
					<cfset gdsData["fafsaDollarsAwarded"] = gdsData["fafsaDollarsAwarded"] + 3678 />
				<cfelse>
					<cfset gdsData["fafsaDollarsAwarded"] = gdsData["fafsaDollarsAwarded"] + 3685 />
				</cfif>
			</cfif>
		</cfif>
		<!--- calgrant submitted --->
		<cfif Len(GPA) gt 0>
			<cfset gdsData["calgrantSubmitted"] = gdsData["calgrantSubmitted"] + 1 />
			<!--- calgrant completed --->
			<cfif Len(Trim(Primary_EFC)) gt 0 and (On_Time_ISIR eq "Y" or On_Time_Dream_Act_Cal_ISIR eq "Y")>
				<cfset gdsData["calgrantCompleted"] = gdsData["calgrantCompleted"] + 1 />
				<cfif Awd_Stat_Code_1 eq "50" or Awd_Stat_Code_1 eq "25" or Awd_Stat_Code_2 eq "50" or Awd_Stat_Code_2 eq "25" or Awd_Stat_Code_3 eq "50" or Awd_Stat_Code_3 eq "25">
					<cfset gdsData["calgrantAwarded"] = gdsData["calgrantAwarded"] + 1 />
					<!--- <cfset gdsData["calgrantDollarsAwarded"] = gdsData["calgrantDollarsAwarded"] + 1 /> --->
					<cfif Awd_Stat_Code_1 eq "50">
						<cfset gdsData["calgrantDollarsAwarded"] = gdsData["calgrantDollarsAwarded"] + Graw_Amt_1 />
						<cfset gdsData["calgrantADollarsAwarded"] = gdsData["calgrantADollarsAwarded"] + Graw_Amt_1 />
						<cfset gdsData["calgrantAAwarded"] = gdsData["calgrantAAwarded"] + 1 />
					<cfelseif Awd_Stat_Code_2 eq "50">
						<cfset gdsData["calgrantDollarsAwarded"] = gdsData["calgrantDollarsAwarded"] + Graw_Amt_2 />
						<cfset gdsData["calgrantBDollarsAwarded"] = gdsData["calgrantBDollarsAwarded"] + Graw_Amt_2 />
						<cfset gdsData["calgrantBAwarded"] = gdsData["calgrantBAwarded"] + 1 />
					<cfelseif Awd_Stat_Code_3 eq "50">
						<cfset gdsData["calgrantDollarsAwarded"] = gdsData["calgrantDollarsAwarded"] + Graw_Amt_3 />
						<cfset gdsData["calgrantCDollarsAwarded"] = gdsData["calgrantCDollarsAwarded"] + Graw_Amt_3 />
						<cfset gdsData["calgrantCAwarded"] = gdsData["calgrantCAwarded"] + 1 />
					<cfelseif Awd_Stat_Code_1 eq "25">
						<cfset gdsData["calgrantDollarsAwarded"] = gdsData["calgrantDollarsAwarded"] + Graw_Amt_1 />
						<cfset gdsData["calgrantADollarsAwarded"] = gdsData["calgrantADollarsAwarded"] + Graw_Amt_1 />
						<cfset gdsData["calgrantAAwarded"] = gdsData["calgrantAAwarded"] + 1 />
					<cfelseif Awd_Stat_Code_2 eq "25">
						<cfset gdsData["calgrantDollarsAwarded"] = gdsData["calgrantDollarsAwarded"] + Graw_Amt_2 />
						<cfset gdsData["calgrantBDollarsAwarded"] = gdsData["calgrantBDollarsAwarded"] + Graw_Amt_2 />
						<cfset gdsData["calgrantBAwarded"] = gdsData["calgrantBAwarded"] + 1 />
					<cfelseif Awd_Stat_Code_3 eq "25">
						<cfset gdsData["calgrantDollarsAwarded"] = gdsData["calgrantDollarsAwarded"] + Graw_Amt_3 />
						<cfset gdsData["calgrantCDollarsAwarded"] = gdsData["calgrantCDollarsAwarded"] + Graw_Amt_3 />
						<cfset gdsData["calgrantCAwarded"] = gdsData["calgrantCAwarded"] + 1 />
					</cfif>
				</cfif>
			</cfif>
		</cfif>
	</cfif>
</cfloop>
<cfif gdsData["fafsaSubmitted"] gt 0>
	<cfset gdsData["fafsaSubmittedPercent"] = Int(gdsData["fafsaSubmitted"]/baseResponses*100) />
	<cfset gdsData["fafsaCompletedPercent"] = Int(gdsData["fafsaCompleted"]/gdsData["fafsaSubmitted"]*100) />
	<cfset gdsData["fafsaCompletedGingerbreadCount"] = Int(gdsData["fafsaCompleted"]/gdsData["fafsaSubmitted"]*10) />
<cfelse>
	<cfset gdsData["fafsaSubmittedPercent"] = 0 />
	<cfset gdsData["fafsaCompletedPercent"] = 0 />
	<cfset gdsData["fafsaCompletedGingerbreadCount"] = 0 />
</cfif>
<cfset gdsData["fafsaSubmittedGingerbreadCount"] = 10 - gdsData["fafsaCompletedGingerbreadCount"] />
<cfset gdsData["fafsaCountLeadingCols"] = (Int(gdsData["fafsaCompletedPercent"]/10)) - 1 />
<cfset gdsData["fafsaCountTrailingCols"] = 9 - gdsData["fafsaCountLeadingCols"] />
<cfif gdsData["calgrantSubmitted"] gt 0>
	<cfset gdsData["calgrantSubmittedPercent"] = Int(gdsData["calgrantSubmitted"]/baseResponses*100) />
	<cfset gdsData["calgrantCompletedPercent"] = Int(gdsData["calgrantCompleted"]/gdsData["calgrantSubmitted"]*100) />
	<cfset gdsData["calgrantAwardedPercent"] = Int(gdsData["calgrantAwarded"]/gdsData["calgrantSubmitted"]*100) />
	<cfset gdsData["calgrantAwardedGingerbreadCount"] = Int(gdsData["calgrantAwarded"]/gdsData["calgrantSubmitted"]*10) />
	<cfset gdsData["calgrantCompletedGingerbreadCount"] = Int(gdsData["calgrantCompleted"]/gdsData["calgrantSubmitted"]*10) - gdsData["calgrantAwardedGingerbreadCount"] />
<cfelse>
	<cfset gdsData["calgrantSubmittedPercent"] = 0 />
	<cfset gdsData["calgrantCompletedPercent"] = 0 />
	<cfset gdsData["calgrantAwardedPercent"] = 0 />
	<cfset gdsData["calgrantAwardedGingerbreadCount"] = 0 />
	<cfset gdsData["calgrantCompletedGingerbreadCount"] = 0 />
</cfif>
<cfset gdsData["calgrantSubmittedGingerbreadCount"] = 10 - (gdsData["calgrantAwardedGingerbreadCount"] + gdsData["calgrantCompletedGingerbreadCount"]) />
<cfset gdsData["calgrantCountLeadingColsTop"] = (Int(gdsData["calgrantCompletedPercent"]/10)) - 1 />
<cfset gdsData["calgrantCountTrailingColsTop"] = 9 - gdsData["calgrantCountLeadingColsTop"] />
<cfset gdsData["calgrantCountLeadingColsBottom"] = (Int(gdsData["calgrantAwardedPercent"]/10)) - 1 />
<cfif gdsData["calgrantCountLeadingColsBottom"] gte 1>
	<cfset gdsData["calgrantCountTrailingColsBottom"] = 9 - gdsData["calgrantCountLeadingColsBottom"] - 1 />
<cfelse>
	<cfset gdsData["calgrantCountTrailingColsBottom"] = 8 />
</cfif>

<cfset exportData = StructNew() />
<cfset exportData.Program_Year = Program_Year />
<cfset exportData.Total_Attendees = Int(baseResponses) />
<!--- <cfset exportData.Exact_Dupes = Int(9999999) /> --->
<cfset exportData.Total_Seniors = Int(seniorBaseResponses) />
<cfset exportData.Percent_Seniors = DecimalFormat(seniorBaseResponsePercent) />
<cfset exportData.Total_Non_Seniors = Int(baseResponses - seniorBaseResponses) />
<cfset exportData.Percent_Non_Seniors = 100 - seniorBaseResponsePercent />
<!--- <cfset exportData.Workshops_With_Survey = DecimalFormat(9999999) />
<cfset exportData.Web_Based_Workshops = DecimalFormat(9999999) /> --->
<cfset exportData.GDS_Matches = Int(gdsData["totalCount"]) />
<cfset exportData.Submitted_FAFSA_Dream_Act = Int(gdsData["fafsaSubmitted"]) />
<cfset exportData.Submitted_FAFSA = gdsData["fafsaSubmitted"] - gdsData["dreamersSubmitted"] />
<cfset exportData.Submitted_Dream_Act = Int(gdsData["dreamersSubmitted"]) />
<cfset exportData.Completed_FAFSA_Dream_Act = Int(gdsData["fafsaCompleted"]) />
<cfset exportData.Completed_FAFSA = gdsData["fafsaCompleted"] - gdsData["dreamersCompleted"] />
<cfset exportData.Completed_Dream_Act = Int(gdsData["dreamersCompleted"]) />
<cfset exportData.On_Time_FAFSA_Dream_Act = Int(gdsData["fafsaOnTime"]) />
<cfset exportData.On_Time_FAFSA = gdsData["fafsaOnTime"] - gdsData["dreamersOnTime"] />
<cfset exportData.On_Time_Dream_Act = Int(gdsData["dreamersOnTime"]) />
<cfset exportData.On_Time_Completed_FAFSA_Dream_Act = Int(gdsData["fafsaOnTimeCompleted"]) />
<cfset exportData.On_Time_Completed_FAFSA = gdsData["fafsaOnTimeCompleted"] - gdsData["dreamersOnTimeCompleted"] />
<cfset exportData.On_Time_Completed_Dream_Act = Int(gdsData["dreamersOnTimeCompleted"]) />
<!--- <cfset exportData.Dream_Act_No_App = Int(99999999) />
<cfset exportData.AA_Males = Int(99999999) />
<cfset exportData.Hispanic_Males = Int(99999999) /> --->
<cfset exportData.Cal_Grant_A_Count = Int(gdsData["calgrantAAwarded"]) />
<cfset exportData.Cal_Grant_B_Count = Int(gdsData["calgrantBAwarded"]) />
<cfset exportData.Cal_Grant_C_Count = Int(gdsData["calgrantCAwarded"]) />
<cfset exportData.Cal_Grant_A_Amount = Int(gdsData["calgrantADollarsAwarded"]) />
<cfset exportData.Cal_Grant_B_Amount = Int(gdsData["calgrantBDollarsAwarded"]) />
<cfset exportData.Cal_Grant_C_Amount = Int(gdsData["calgrantCDollarsAwarded"]) />
<cfset exportData.Pell_Eligible = Int(gdsData["fafsaPellEligible"]) />
<!--- <cfset exportData.No_GPA = Int(99999999) />
<cfset exportData.GPA_LT_2 = Int(99999999) />
<cfset exportData.WebGrants_Account = Int(99999999) /> --->

<!--- <cfdump var="#raceAnswers#" expand="no" label="raceData" />
<cfdump var="#gdsData#" expand="no" label="gdsData" />
<cfdump var="#currentEvaluations#" expand="no" label="currentEvaluations" />
<cfabort> --->

<!--- <cfdump var="#exportData#">
<cfabort> --->

<!DOCTYPE html>
<html>
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<title>Cash for College How Did We Do Report</title>
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<meta name="description" content="Cash for College How Did We Do Report">
	<meta name="author" content="Syntric">
	<link href="/assets/kendoui/styles/kendo.common.min.css" rel="stylesheet" type="text/css" />
	<link href="/assets/kendoui/styles/kendo.rtl.min.css" rel="stylesheet" type="text/css" />
	<link href="/assets/kendoui/styles/kendo.default.min.css" rel="stylesheet" type="text/css" />
	<link href="/assets/kendoui/styles/kendo.dataviz.min.css" rel="stylesheet" type="text/css" />
	<link href="/assets/kendoui/styles/kendo.dataviz.default.min.css" rel="stylesheet" type="text/css" />
	<link href="/assets/kendoui/styles/kendo.mobile.all.min.css" rel="stylesheet" type="text/css" />
	<link href="/assets/fonts/cabin/cabin.css" rel="stylesheet" type="text/css" />
	<link href="/assets/fonts/cabin-condensed/cabin-condensed.css" rel="stylesheet" type="text/css" />
	<link href="/assets/fonts/open-sans/open-sans.css" rel="stylesheet" type="text/css" />
	<link href="/assets/fonts/open-sans-condensed/open-sans-condensed.css" rel="stylesheet" type="text/css" />
	<link href="/assets/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css" />
	<link href="/assets/font-awesome/css/font-awesome-ie7.min.css" rel="stylesheet" type="text/css" />
	<script src="/assets/jquery/jquery.min.js" type="text/javascript"></script>
	<script src="/assets/kendoui/js/kendo.all.min.js"></script>
	<style type="text/css">
		body {font-family: "Open Sans", courier; background-color: #fff; margin: 0; padding: 0; text-rendering: optimizelegibility;}
		
		.default {color: #aad9e7;}
		.aqua {color: #55b4d0;}
		.blue {color: #2682d6;}
		.blueDark {color: #0f2a88;}
		.green {color: #5dba5d;}
		.greenDark {color: #417630;}
		.greyDark {color: #444444;}
		.greyLight {color: #aaa89a;}
		.white {color: #fff;}
		.goldDark {color: #C90;}
		
		.printPage {width: 1125px; max-height: 1455px; height: 1455px; border: solid 0 #000; page-break-inside: avoid !important;}
		.main {width: 1125px; max-height: 1455px; height: 1455px; page-break-inside: avoid !important;}
		.navCol {width: 160px; padding-top: 12px; background-image: url('/assets/calgrants/ui/images/hdwd/nav-col-bg.png'); background-repeat: repeat-y; background-size: contain;}
		.bodyCol {width: 965px; padding-top: 16px; background-color: #fff;}
		.nav {width: 160px;}
		.navHeader {width: 160px; height: 247px; background-image: url('/assets/calgrants/ui/images/hdwd/nav-col-header-shadow-background.png'); background-repeat: no-repeat; background-size: contain;}
		.navBody {padding: 0 10px;}
		h3.blue, h3.blueDark {margin: 0px; -webkit-margin-before: 0px; -webkit-margin-after: 0px; -webkit-margin-start: 0px; -webkit-margin-end: 0px; padding: 0px;}
		
		/* column width classes */
		.col21w {min-width: 21px; width: 21px; max-width: 21px;} /* center col spacer */
		.col90w {min-width: 90px; width: 90px; max-width: 90px;} /* teardrop, tearpanel */
		.col152w {min-width: 152px; width: 152px; max-width: 152px;} /* legend */
		.col160w {min-width: 160px; width: 160px; max-width: 160px;} /* nav */
		.col186w {min-width: 186px; width: 186px; max-width: 186px;} /* dollar award */
		.col210w {min-width: 210px; width: 210px; max-width: 210px;} /* dollar award */
		.col242w {min-width: 242px; width: 242px; max-width: 242px;} /* arrow */
		.col266w {min-width: 266px; width: 266px; max-width: 266px;} /* arrow */
		.col300w {min-width: 300px; width: 300px; max-width: 300px;} /* donut chart */
		.col362w {min-width: 362px; width: 362px; max-width: 362px;} /* gingerbread chart */
		.col452w {min-width: 452px; width: 452px; max-width: 452px;} /* stat header, half body col */
		/* column height classes */
		.col40h {min-height: 40px; max-height: 40px; height: 40px;}
		.col60h {min-height: 60px; max-height: 60px; height: 60px;}
		.col80h {min-height: 80px; max-height: 80px; height: 80px;}
		.col115h {min-height: 115px; max-height: 115px; height: 115px;}
		.col215h {min-height: 215px; max-height: 215px; height: 215px;}
		.col274h {min-height: 274px; max-height: 274px; height: 274px;}
		.col300h {min-height: 300px; max-height: 300px; height: 300px;}

		.logo {width: 131px;}
		.logoText {max-height: 128px;}
		/*.howDid {font-family: "Cabin Condensed"; font-size: 2.1em; text-align: center; line-height: 1em;}
		.weDo {font-family: "Cabin Condensed"; font-size: 2.9em; text-align: center; line-height: 1em;}*/
		.logoYearText {font-family: "Cabin Condensed"; font-size: 2.8em; color: gold; text-align: center; display: block;}
		.sideLabel {font-family: "Open Sans Bold"; font-size: 0.9em; margin-bottom: 0;}
		.sideText {font-family: "Open Sans Condensed Light"; font-size: 1.4em; margin-bottom: 10px; line-height: 1em;}
		.statHeader {font-family: "Cabin Condensed Semibold"; font-size: 1.6em;}
		.mission {font-size: 0.9em; color: #fff; line-height: 1.2em; padding: 10px;}

		hr {border: 0; border-bottom: 3px solid #ccc; background: #fff;}

		.gingerbreadTopRow td, .gingerbreadBottomRow td  {font-family: "Open Sans Bold"; width: 34px; max-width: 34px; min-width: 34px; height: 48px; font-size: 0.7em; line-height: 1em; text-align: center;}
		<cfif baseResponses gte 10000>
			.gingerbreadTopRow td, .gingerbreadBottomRow td  {font-size: 0.6em;}
		</cfif>
		.gingerbreadUpperRow td, .gingerbreadLowerRow td {width: 34px; max-width: 34px; min-width: 34px; height: 84px;}
		
		/* gingerbread backgrounds */
		.femaleGreen {background-image: url('/assets/calgrants/ui/images/hdwd/female-green.png'); background-repeat: no-repeat; background-position: center; background-size: contain;}
		.femaleBlue {background-image: url('/assets/calgrants/ui/images/hdwd/female-blue.png'); background-repeat: no-repeat; background-position: center; background-size: contain;}
		.femaleDefault {background-image: url('/assets/calgrants/ui/images/hdwd/female-default.png'); background-repeat: no-repeat; background-position: center; background-size: contain;}
		.maleGreen {background-image: url('/assets/calgrants/ui/images/hdwd/male-green.png'); background-repeat: no-repeat; background-position: center; background-size: contain;}
		.maleBlue {background-image: url('/assets/calgrants/ui/images/hdwd/male-blue.png'); background-repeat: no-repeat; background-position: center; background-size: contain;}
		.maleDefault {background-image: url('/assets/calgrants/ui/images/hdwd/male-default.png'); background-repeat: no-repeat; background-position: center; background-size: contain;}
	
		/* review this */
		<cfif gdsData["totalCount"] lt 10000>
		.teardropSmall td {width: 70px; height: 70px; color: #fff; font-size: 0.6em; font-weight: 700; line-height: 1.2em; background-repeat: no-repeat; background-position: center; background-size: contain;}
		.upsize150 {font-size: 1.5em; font-weight: 700;}
		<cfelse>
		.teardropSmall td {width: 70px; height: 70px; color: #fff; font-size: 0.6em; font-weight: 700; line-height: 1.2em; background-repeat: no-repeat; background-position: center; background-size: contain;}
		.upsize150 {font-size: 1.4em; font-weight: 700;}
		</cfif>
		.teardropHalfSmall td {height: 35px;}
		.defaultTeardropNESmall {background-image: url('/assets/calgrants/ui/images/hdwd/default-teardrop-ne-small.png');}
		.aquaTeardropNESmall {background-image: url('/assets/calgrants/ui/images/hdwd/aqua-teardrop-ne-small.png');}
		.blueTeardropNESmall {background-image: url('/assets/calgrants/ui/images/hdwd/blue-teardrop-ne-small.png');}
		.blueDarkTeardropNESmall {background-image: url('/assets/calgrants/ui/images/hdwd/blue-dark-teardrop-ne-small.png');}
		.greenTeardropNESmall {background-image: url('/assets/calgrants/ui/images/hdwd/green-teardrop-ne-small.png');}
		.greenDarkTeardropNESmall {background-image: url('/assets/calgrants/ui/images/hdwd/green-dark-teardrop-ne-small.png');}
		.greyDarkTeardropNESmall {background-image: url('/assets/calgrants/ui/images/hdwd/grey-dark-teardrop-ne-small.png');}
		.defaultTeardropNWSmall {background-image: url('/assets/calgrants/ui/images/hdwd/default-teardrop-nw-small.png');}
		.aquaTeardropNWSmall {background-image: url('/assets/calgrants/ui/images/hdwd/aqua-teardrop-nw-small.png');}
		.blueTeardropNWSmall {background-image: url('/assets/calgrants/ui/images/hdwd/blue-teardrop-nw-small.png');}
		.blueDarkTeardropNWSmall {background-image: url('/assets/calgrants/ui/images/hdwd/blue-dark-teardrop-nw-small.png');}
		.greenTeardropNWSmall {background-image: url('/assets/calgrants/ui/images/hdwd/green-teardrop-nw-small.png');}
		.greenDarkTeardropNWSmall {background-image: url('/assets/calgrants/ui/images/hdwd/green-dark-teardrop-nw-small.png');}
		.greyDarkTeardropNWSmall {background-image: url('/assets/calgrants/ui/images/hdwd/grey-dark-teardrop-nw-small.png');}
	
		/* check this font-weight */
		.tearpanel td {width: 35px; height: 130px; font-family: "Open Sans Semibold"; color: #fff; font-size: 0.8em; line-height: 1em; background-repeat: no-repeat; background-size: contain;}
		.femaleTearpanel {background-image: url('/assets/calgrants/ui/images/hdwd/female-tearpanel.png'); background-position: top;}
		.maleTearpanel {background-image: url('/assets/calgrants/ui/images/hdwd/male-tearpanel.png'); background-position: bottom;}
	
		.ratingPercentRow td {font-family: "Open Sans Condensed Bold"; font-size: 4em; text-align: center; line-height: 1em; padding: 6px;}
		.ratingPercentLabelRow td {font-family: "Cabin Semibold"; font-size: 1.4em; text-align: center; line-height: 1em; padding: 6px;}
		span.ratingPercentSymbol {font-size: 0.8em;}
		
		.legendTable td {font-size: 0.8em; padding: 4px 2px; line-height: 1em; font-weight: 500; color: #444444;}
		
		#genderPercentages td {color: #fff; font-size: 0.8em; font-weight: bold; text-align: center; vertical-align: middle;}
		.trendChartLabel {font-size: 1em; line-height: 1.2em; padding-bottom: 2px; color: #444444; height: 40px; text-align: left; vertical-align: middle;}
		/*.arrow {font-family: "Open Sans Semibold"; background-repeat: no-repeat; background-position: left; background-size: contain; font-size: 0.8em; color: #fff; padding-left: 6px; line-height: 1.2em;}
		.blueArrowRight {background-image: url('/assets/calgrants/ui/images/hdwd/blue-arrow-right.png');}
		.greenArrowRight {background-image: url('/assets/calgrants/ui/images/hdwd/green-arrow-right.png');}*/
		<cfif gdsData["calgrantDollarsAwarded"] lt 1000000>
			.dollarAward {font-family: "Open Sans Condensed Bold"; font-size: 2.6em; color: #5dba5d; text-align: right; padding-right: 4px;}
		<cfelse>
			.dollarAward {font-family: "Open Sans Condensed Bold"; font-size: 2.2em; color: #5dba5d; text-align: right; padding-right: 4px;}
		</cfif>
		.sourceInfo {margin: 10px;}
		.sourceInfo p {font-size: 0.9em; line-height: 1.3em;}
		.svgChart {display: none;}
	</style>
	<script type="application/javascript">
	<!--
		<cfoutput>
			var programYears = [#QuotedValueList(getProgramYears.Program_Year)#];
			var currentData = #SerializeJSON(currentData)#;
			var trendData = #SerializeJSON(trendData)#;
			var rollupLevel = "#rollupLevel#";
			var oId = #oID#;
			var colors = #SerializeJSON(colors)#;
		</cfoutput>
		
		var donutLabelTemplate = "#= dataItem.percent#%";
		var donutLegendTemplate = "#= dataItem.name#";
		
		var pieLabelTemplate = "#= dataItem.name# - #= dataItem.percent#%";
		var pieLegendTemplate = "#= dataItem.name# - #= dataItem.percent#%";
		var pieTooltipTemplate = "#= dataItem.name# - #= dataItem.percent#";
		var donutTooltipTemplate = "#= dataItem.count# responses = #= dataItem.percent#%";
		var barLabelTemplate = "#= dataItem.name# - #= dataItem.percent#%";
		var barLegendTemplate = "#= text#";
		var barTooltipTemplate = "#= dataItem.count# responses = #= dataItem.percent#%";
		var donutLabelFont = "9px Arial,Helvetical,sans-serif";
		var labelFont = "9px Arial,Helvetical,sans-serif";
		var legendFont = "9px Arial,Helvetical,sans-serif";
		var tooltipFont = "9px Arial,Helvetical,sans-serif";

		getCurrentQuestionData = function(q) {
			var d = currentData[q]["ANSWERS"];
			var r = [];
			for (var k in d) {
				var s = {};
				if (q == 7) {
					if (d[k]["ANSWER"] == true) {
						s["name"] = "Senior";
					} else if (d[k]["ANSWER"] == false) {
						s["name"] = "Non-senior";
					} else {
						s["name"] = "Family member of senior";
					}
				} else {
					if (d[k]["ANSWER"] == true) {
						s["name"] = "Yes";
					} else if (d[k]["ANSWER"] == false) {
						s["name"] = "No";
					} else {
						s["name"] = d[k]["ANSWER"];
					}
				}
				s["count"] = parseInt(d[k]["RESPONSE_COUNT"]);
				s["percent"] = parseInt(d[k]["RESPONSE_PERCENT"]);
				r.push(s);
			}
			return r;
		}
		getTrendQuestionData = function(q) {
			var d = trendData[q]["ANSWERS"];
			var r = [];
			for (var k in d) {
				var s = {};
				s["counts"] = [];
				s["percents"] = [];
				s["data"] = [];
				for (var j=0; j<d[k].length; j++) {
					s["name"] = d[k][j]["ANSWER"];
					s["counts"].push(parseInt(d[k][j]["RESPONSE_COUNT"]));
					s["percents"].push(parseInt(d[k][j]["RESPONSE_PERCENT"]));
					s["data"].push(parseInt(d[k][j]["RESPONSE_PERCENT"]));
				}
				r.push(s);
			}
			return r;
		}
		
		renderDonutChart = function(q) {
			$("#q" + q + "DonutChart").kendoChart({
				renderAs: "svg",
				series: [{
					type: "donut",
					data: getCurrentQuestionData(q),
					field: "percent",
					categoryField: "name",
					overlay: "",
					startAngle: 90,
					labels: {
						align: "circle",
						color: "#444444",
						distance: 16,
						position: "outsideEnd",
						template: donutLabelTemplate,
						visible: true
					},
					border: {width: 2, color: "#fff"},
					visibleInLegend: false
				}],
				chartArea: {
					width: 290,
					height: 290,
					margin: 0
				},
				seriesColors: colors,
				legend: {
					visible: false,
					position: "bottom",
					labels: {
						font: donutLabelFont,
						template: donutLegendTemplate
					}
				},
				tooltip: {
					visible: false,
					//font: tooltipFont,
					template: donutTooltipTemplate
				}
			})
		}
		renderTrendLineChart = function(q) {
			$("#q" + q + "TrendLineChart").kendoChart({
				renderAs: "svg",
				legend: {visible: false},
				seriesDefaults: {
					type: "line",
					opacity: 1
				},
				series: getTrendQuestionData(q),
				seriesColors: colors,
				chartArea: {
					width: 445,
					height: 300
				},
				valueAxis: {
					min: 0,
					max: 100,
					labels: {format: "{0}%", color: "#444444"},
					line: {visible: false}, 
					majorUnit: 25,
					minorUnit: 12.5,
					majorGridLines: {visible: true, width: 1, dashType: "dot"},
					minorGridLines: {visible: true, width: 1, dashType: "dot"}
				},
				categoryAxis: {
					categories: programYears,
					labels: {
						template: function(d) {
							return d.value.split("-")[1];
						},
						color: "#444444",
						rotation: -45
					},
					line: {visible: false},
					majorGridLines: {visible: false},
					minorGridLines: {visible: false}	
				}
			})
		}
		renderTrendAreaChart = function(q) {
			$("#q" + q + "TrendAreaChart").kendoChart({
				renderAs: "svg",
				legend: {visible: false},
				seriesDefaults: {
					type: "area",
					opacity: 1
				},
				series: getTrendQuestionData(q),
				seriesColors: colors,
				chartArea: {
					width: 445,
					height: 300
				},
				valueAxis: {
					min: 0,
					max: 100,
					labels: {format: "{0}%", color: "#444444"},
					line: {visible: false}, 
					majorUnit: 25,
					minorUnit: 12.5,
					majorGridLines: {visible: true, width: 1, dashType: "dot"},
					minorGridLines: {visible: true, width: 1, dashType: "dot"}
				},
				categoryAxis: {
					categories: programYears,
					labels: {
						template: function(d) {
							return d.value.split("-")[1];
						},
						color: "#444444",
						rotation: -45
					},
					line: {visible: false},
					majorGridLines: {visible: false},
					minorGridLines: {visible: false}	
				}
			})
		}
		getChartImage = function(q) {
			var chart = $("#q" + q + "DonutChart").data("kendoChart");
			//console.log(chart);
			var png = chart.imageDataURL();
			/*console.log(png);
			if (!window.open(png)) {
				document.location.href = png;
			}*/
		}
		generatePNGs = function() {
			var svgCharts = $(".svgDonutChart");
			if (programYears.length > 1) {
				svgCharts.concat($(".svgTrendLineChart"), $(".svgTrendAreaChart"));
			}
			var pngCharts = [];
			var dest = 'C\:\\inetpub\\assets\\calgrants\\temp\\';
			for (var i=0; i<svgCharts.length; i++) {
				//console.log($("#" + svgCharts[i].id).data("kendoChart").imageDataURL());
				var chartId = svgCharts[i].id;
				var svgChart = $("#" + chartId).data("kendoChart");
				var pngBase64 = svgChart.imageDataURL();
				//console.log(pngBase64);
				var chartFileName = chartId + "_" + rollupLevel + "_" + oId;
				//console.log("--------- Generating PNG " + chartId + " ---------");
				$.ajax({
					type: "post",
					url: "/assets/calgrants/com/API.cfc?method=generatePNG",
					data: {"pngBase64String": pngBase64, "destination": dest + chartFileName + ".png"},
					async: true,
					cache: false,
					dataType: "json",
					success: function(response, textStatus, jqXHR){
						//console.log("--------- Successfully generated PNG " + chartFileName + " ---------");
						var pathStrArray = response.DATA.split("\\");
						var fileNameStrArray = pathStrArray[pathStrArray.length - 1].split("_");
						var divId = fileNameStrArray[0] + "PNG";
						//console.log(pathStrArray[pathStrArray.length - 1]);
						$("#" + divId + " img").attr("src", "\/assets\/calgrants\/temp\/" + pathStrArray[pathStrArray.length - 1]);
					},
					error: function(jqXHR, textStatus, errorThrown){
						//console.log("--------- Error generating PNG " + chartFileName + " ---------");
						//console.log(errorThrown);
					}
				});
			}
		}
		$(function() {
			renderDonutChart(6);
			renderDonutChart(7);
			renderDonutChart(10);
			renderDonutChart(12);
			if (programYears.length > 1) {
				renderTrendLineChart(1);
				renderTrendLineChart(11);
				renderTrendAreaChart(7);
				renderTrendLineChart(12);
				renderTrendLineChart(6);
				renderTrendLineChart(10);
			}
			/*window.setTimeout(function() {
				generatePNGs();
			}, 7000);*/
		})
	//-->
	</script>
</head>

<body>
<cfoutput>
	<cfif ListLen(programYears) lte 1>
		<!--- non-trend --->
		<div class="printPage">
			<table class="main" border="0" cellpadding="0" cellspacing="0">
				<tr valign="top">
					<td class="navCol" valign="top">
						<table class="nav" border="0" cellpadding="0" cellspacing="0">
							<tr valign="top">
								<td class="navHeader" align="center">
									<table border="0" cellpadding="0" cellspacing="0" style="border-spacing: 0px;">
										<tr>
											<td class="logo" align="center"><img src="/assets/calgrants/ui/images/hdwd/cash-for-college-logo_hires.png" /></td>
										<tr>
											<td class="logoText" align="center">
												<img src="/assets/calgrants/ui/images/hdwd/how-did-we-do-cropped.png" />
												<div class="logoYearText">IN&nbsp;#ListLast(Program_Year, "-")#</div>
											</td>
										</tr>
									</table>
								</td>
							</tr>
							<tr valign="top">
								<td class="navBody">
									<cfif IsDefined("site")>
										<div class="sideLabel greyDark">Site Name</div>
										<div class="sideText white">#site#</div>
									</cfif>
									<cfif IsDefined("siteType")>
										<div class="sideLabel greyDark">Site Type</div>
										<div class="sideText white">#siteType#</div>
									</cfif>
									<cfif IsDefined("siteSince")>
										<div class="sideLabel greyDark">Site Since</div>
										<div class="sideText white">#siteSince#</div>
									</cfif>
									<cfif IsDefined("city")>
										<div class="sideLabel greyDark">City</div>
										<div class="sideText white">#city#</div>
									</cfif>
									<cfif IsDefined("county")>
										<div class="sideLabel greyDark">County</div>
										<div class="sideText white">#county#</div>
									</cfif>
									<cfif IsDefined("region")>
										<div class="sideLabel greyDark">Region</div>
										<div class="sideText white">#region#</div>
									</cfif>
									<cfif IsDefined("workshopDate")>
										<div class="sideLabel greyDark">Workshop Date</div>
										<div class="sideText white">#DateFormat(workshopDate, "mmmm d, yyyy")#</div>
									</cfif>
									<cfif IsDefined("computerBasedWorkshop")>
										<div class="sideLabel greyDark">Computer Based Workshop</div>
										<div class="sideText white">#YesNoFormat(computerBasedWorkshop)#</div>
									</cfif>
									<cfif IsDefined("organization")>
											<div class="sideLabel greyDark"><cfif Workshop_ID gt 0 or Site_ID gt 0>Lead </cfif>Organization</div>
											<div class="sideText white">#organization#</div>
									</cfif>
									<cfif IsDefined("organizationSince")>
										<div class="sideLabel greyDark">Organization Since</div>
										<div class="sideText white">#organizationSince#</div>
									</cfif>
									<div class="sideLabel greyDark">Total Attendees</div>
									<div class="sideText white">#NumberFormat(baseResponses)#</div>
									<div class="sideLabel greyDark">Senior Attendees</div>
									<div class="sideText white">#NumberFormat(seniorBaseResponses)# (#Int(seniorBaseResponsePercent)#%)</div>
									<cfif IsDefined("followUpRequests") and IsDefined("followUpRequestsPct")>
										<div class="sideLabel greyDark">Follow-Up Requests</div>
										<div class="sideText white">#followUpRequests# (#Int(followUpRequestsPct)#%)</div>
									</cfif>
									<cfif IsDefined("followedUp")>
										<div class="sideLabel greyDark">Used Follow-Up Platform?</div>
										<div class="sideText white"><cfif followedUp gt 0>Yes (#followedUp#)<cfelse>No</cfif></div>
									</cfif>
									<cfif scholarshipCounts.RecordCount gt 0>
										<cfif Workshop_ID gt 0>
											<div class="sideLabel greyDark">Cash for College Scholarship Awarded?</div>
											<div class="sideText white">Yes</div>
										<cfelse>
											<div class="sideLabel greyDark">Scholarships Awarded</div>
											<div class="sideText white">Yes</div>
										</cfif>
									</cfif>
								</td>
							</tr>
						</table>
					</td>
					<td class="bodyCol" align="center" rowspan="2">
						<table border="0" cellpadding="0" cellspacing="0">
							<tr>
								<td class="col452w col40h statHeader">FAFSA/DREAM ACT APPLICATIONS</td>
								<td class="col21w col40h">&nbsp;</td>
								<td class="col452w col40h statHeader">CAL GRANT APPLICATIONS</td>
							</tr>
							<tr valign="top">
								<td class="col452w col215h">
									<table border="0" cellpadding="0" cellspacing="0">
										<tr>
											<td class="col362w">
												<!--- gingerbread --->
												<table id="fafsaCounts" border="0" cellpadding="0" cellspacing="2" class="gingerbreadTable">
													<tr class="gingerbreadTopRow">
														<cfif gdsData.fafsaCountLeadingCols gt 0>
															<td colspan="#gdsData.fafsaCountLeadingCols#">&nbsp;</td>
														</cfif>
														<td class="blueMarkerDown">#NumberFormat(gdsData.fafsaCompleted)#<br /><i class="icon-caret-down icon-3x blue"></i></td>
														<cfif gdsData.fafsaCountTrailingCols gt 0>
															<td colspan="#gdsData.fafsaCountTrailingCols#">&nbsp;</td>
														</cfif>
													</tr>
													<tr class="gingerbreadUpperRow">
														<cfset gender = "female">
														<cfloop index="i" from="1" to="#gdsData.fafsaCompletedGingerbreadCount#">
															<td class="#gender#Blue"></td>
															<cfif gender eq "female">
																<cfset gender = "male" />
															<cfelse>
																<cfset gender = "female">
															</cfif>
														</cfloop>
														<cfloop index="i" from="1" to="#gdsData.fafsaSubmittedGingerbreadCount#">
															<td class="#gender#Default"></td>
															<cfif gender eq "female">
																<cfset gender = "male" />
															<cfelse>
																<cfset gender = "female">
															</cfif>
														</cfloop>
													</tr>
													<tr class="gingerbreadBottomRow">
														<td colspan="9"></td>
														<td class="defaultMarkerUp"><i class="icon-caret-up icon-3x aqua"></i><br />#NumberFormat(gdsData.fafsaSubmitted)#</td>
													</tr>
												</table>
											</td>
											<td class="col90w" align="right">
												<!--- teardrops --->
												<table id="fafsaPercentages" border="0" cellpadding="0" cellspacing="1">
													<tr class="teardropHalfSmall">
														<td></td>
													</tr>
													<tr class="teardropSmall">
														<td valign="middle" align="center" class="aquaTeardropNWSmall"><span class="upsize150">#gdsData.fafsaSubmittedPercent#%</span><br />Submitted</td>
													</tr>
													<tr class="teardropSmall">
														<td valign="middle" align="center" class="blueTeardropNESmall"><span class="upsize150">#gdsData.fafsaCompletedPercent#%</span><br />Complete</td>
													</tr>
													<tr class="teardropHalfSmall">
														<td></td>
													</tr>
												</table>
											</td>
										</tr>
									</table>
								</td>
								<td class="col21w col215h">&nbsp;</td>
								<td class="col452w col215h">
									<table border="0" cellpadding="0" cellspacing="0">
										<tr>
											<td class="col362w">
												<!--- gingerbread --->
												<table id="calgrantCounts" border="0" cellpadding="0" cellspacing="2" class="gingerbreadTable">
													<tr class="gingerbreadTopRow">
														<cfif gdsData.calgrantCountLeadingColsTop gt 0>
															<td colspan="#gdsData.calgrantCountLeadingColsTop#">&nbsp;</td>
														</cfif>
														<td class="blueMarkerDown">#NumberFormat(gdsData.calgrantCompleted)#<br /><i class="icon-caret-down icon-3x blue"></i></td>									
														<cfif gdsData.calgrantCountTrailingColsTop gt 0>
															<td colspan="#gdsData.calgrantCountTrailingColsTop#">&nbsp;</td>
														</cfif>
													</tr>
													<tr class="gingerbreadUpperRow">
														<cfset gender = "female">
														<cfloop index="i" from="1" to="#gdsData.calgrantAwardedGingerbreadCount#">
															<td class="#gender#Green"></td>
															<cfif gender eq "female">
																<cfset gender = "male" />
															<cfelse>
																<cfset gender = "female">
															</cfif>
														</cfloop>
														<cfloop index="i" from="1" to="#gdsData.calgrantCompletedGingerbreadCount#">
															<td class="#gender#Blue"></td>
															<cfif gender eq "female">
																<cfset gender = "male" />
															<cfelse>
																<cfset gender = "female">
															</cfif>
														</cfloop>
														<cfloop index="i" from="1" to="#gdsData.calgrantSubmittedGingerbreadCount#">
															<td class="#gender#Default"></td>
															<cfif gender eq "female">
																<cfset gender = "male" />
															<cfelse>
																<cfset gender = "female">
															</cfif>
														</cfloop>
													</tr>
													<tr class="gingerbreadBottomRow">
														<cfif gdsData.calgrantCountLeadingColsBottom gt 0>
															<td colspan="#gdsData.calgrantCountLeadingColsBottom#">&nbsp;</td>
														</cfif>
														<td class="greenMarkerUp"><i class="icon-caret-up icon-3x green"></i><br />#NumberFormat(gdsData.calgrantAwarded)#</td>	
														<cfif gdsData.calgrantCountTrailingColsBottom gt 0>
															<td colspan="#gdsData.calgrantCountTrailingColsBottom#">&nbsp;</td>
														</cfif>
														<cfif gdsData.calgrantAwarded neq gdsData.calgrantSubmitted>
															<td class="defaultMarkerUp"><i class="icon-caret-up icon-3x aqua"></i><br />#NumberFormat(gdsData.calgrantSubmitted)#</td>
														</cfif>
													</tr>
												</table>
											</td>
											<td class="col90w" align="right">
												<!--- teardrops --->
												<table id="calgrantPercentages" border="0" cellpadding="0" cellspacing="1">
													<tr class="teardropSmall">
														<td valign="middle" align="center" class="aquaTeardropNWSmall"><span class="upsize150">#gdsData.calgrantSubmittedPercent#%</span><br />Submitted</td>
													</tr>
													<tr class="teardropSmall">
														<td valign="middle" align="center" class="blueTeardropNESmall"><span class="upsize150">#gdsData.calgrantCompletedPercent#%</span><br />Complete</td>
													</tr>
													<tr class="teardropSmall">
														<td valign="middle" align="center" class="greenTeardropNESmall"><span class="upsize150">#gdsData.calgrantAwardedPercent#%</span><br />Offered</td>
													</tr>
												</table>
											</td>
										</tr>
									</table>
								</td>
							</tr>
							<tr valign="top">
								<td class="col452w col80h">
									<!--- arrow --->
									<table border="0" cellpadding="0" cellspacing="0" width="100%">
										<tr class="dollarArrow">
											<td class="arrow">
												<img src="/assets/calgrants/ui/images/hdwd/pell-grant-arrow.png">
											</td>
											<td class="dollarAward" nowrap="nowrap" width="100%">$#NumberFormat(gdsData.fafsaDollarsAwarded)#</td>
										</tr>
									</table>
								</td>
								<td class="col21w col80h">&nbsp;</td>
								<td class="col452w col80h">
									<!--- arrow --->
									<table border="0" cellpadding="0" cellspacing="0" width="100%">
										<tr class="dollarArrow">
											<td class="arrow">
												<img src="/assets/calgrants/ui/images/hdwd/cal-grant-arrow.png">
											</td>
											<td class="dollarAward" nowrap="nowrap" width="100%">$#NumberFormat(gdsData.calgrantDollarsAwarded)#</td>
										</tr>
									</table>
								</td>
							</tr>
							<tr>
								<td colspan="3"><hr /></td>
							</tr>
							<tr>
								<td class="col452w col40h statHeader">WORKSHOP RATING</td>
								<td class="col21w col40h">&nbsp;</td>
								<td class="col452w col40h statHeader">ATTENDANCE by GENDER</td>
							</tr>
							<tr valign="middle">
								<td class="col452w col274h">
									<!--- rating --->
									<table id="workshopRating" border="0" cellpadding="0" cellspacing="0">
										<tr class="ratingPercentRow">
											<td class="ratingPercent blue" width="25%">#Int(currentData[1].answers[1].response_percent)#<span class="ratingPercentSymbol">%</span></td>
											<td class="ratingPercent green" width="25%">#Int(currentData[1].answers[2].response_percent)#<span class="ratingPercentSymbol">%</span></td>
											<td class="ratingPercent blueDark" width="25%">#Int(currentData[1].answers[3].response_percent)#<span class="ratingPercentSymbol">%</span></td>
											<td class="ratingPercent aqua" width="25%">#Int(currentData[1].answers[4].response_percent)#<span class="ratingPercentSymbol">%</span></td>
										</tr>
										<tr class="ratingPercentLabelRow">
											<td>Excellent</td>
											<td>Good</td>
											<td>Fair</td>
											<td>Poor</td>
										</tr>
									</table>
								</td>
								<td class="col21w col274h">&nbsp;</td>
								<td class="col452w col274h">
									<table border="0" cellpadding="0" cellspacing="0">
										<tr>
											<td class="col362w">
												<!--- gingerbread --->
												<table id="genderCounts" border="0" cellpadding="0" cellspacing="2" class="gingerbreadTable" width="100%">
													<tr class="gingerbreadTopRow">
														<cfif genderData.femaleCountLeadingCols gt 0>
															<td colspan="#genderData.femaleCountLeadingCols#">&nbsp;</td>
														</cfif>
														<td class="greenMarkerDown">#NumberFormat(genderData.femaleCount)#<br /><i class="icon-caret-down icon-3x green"></i></td>
														<cfif genderData.femaleCountTrailingCols gt 1>
															<td colspan="#genderData.femaleCountTrailingCols#">&nbsp;</td>
														</cfif>
													</tr>
													<tr class="gingerbreadUpperRow">
														<cfloop index="i" from="1" to="#genderData.femaleOnCount#">
															<td class="femaleGreen"></td>
														</cfloop>
														<cfloop index="i" from="1" to="#genderData.femaleOffCount#">
															<td class="femaleDefault"></td>
														</cfloop>
													</tr>
													<tr class="gingerbreadLowerRow">
														<cfloop index="i" from="1" to="#genderData.maleOnCount#">
															<td class="maleBlue"></td>
														</cfloop>
														<cfloop index="i" from="1" to="#genderData.maleOffCount#">
															<td class="maleDefault"></td>
														</cfloop>
													</tr>
													<tr class="gingerbreadBottomRow">
														<cfif genderData.maleCountLeadingCols gt 0>
															<td colspan="#genderData.maleCountLeadingCols#">&nbsp;</td>
														</cfif>
														<td class="blueMarkerUp"><i class="icon-caret-up icon-3x blue"></i><br />#NumberFormat(genderData.maleCount)#</td>
														<cfif genderData.maleCountTrailingCols gt 0>
															<td colspan="#genderData.maleCountTrailingCols#">&nbsp;</td>
														</cfif>
														<td class="defaultMarkerUp"><i class="icon-caret-up icon-3x aqua"></i><br />#NumberFormat(genderData.maleFemaleCount)#</td>
													</tr>
												</table>
											</td>
											<td class="col90w" align="right">
												<!--- tearpanels --->
												<table id="genderPercentages" border="0" cellpadding="0" cellspacing="1">
													<tr class="tearpanel">
														<td valign="top" class="femaleTearpanel">#Int(genderData.femalePercent)#%</td>
														<td valign="bottom" class="maleTearpanel">#Int(genderData.malePercent)#%</td>
													</tr>
												</table>

											</td>
										</tr>
									</table>
								</td>
							</tr>
							<tr>
								<td colspan="3"><hr /></td>
							</tr>
							<tr>
								<td class="col452w col40h statHeader">SENIOR ATTENDANCE</td>
								<td class="col21w col40h">&nbsp;</td>
								<td class="col452w col40h statHeader">ATTENDANCE by RACE/ETHNICITY</td>
							</tr>
							<tr valign="top">
								<td class="col452w col300h">
									<table border="0" cellpadding="0" cellspacing="0">
										<tr>
											<td class="col300w col300h"><div id="q7DonutChart" class="svgDonutChart"></div></td>
											<td class="col152w col300h">
												<!--- legend --->
												<cfset answerData = currentData[7].answers />
												<table border="0" cellpadding="0" cellspacing="0" class="legendTable">
													<cfloop index="a" from="1" to="#ArrayLen(answerData)#">
														<tr valign="top">
															<td style="color: #colors[a]#;"><i class="icon-stop"></i></td>
															<td align="left" width="100%">
																<cfif answerData[a]["answer"] eq "yes" or answerData[a]["answer"] eq true>
																	Yes
																<cfelseif answerData[a]["answer"] eq "no" or answerData[a]["answer"] eq false>
																	No
																<cfelse>
																	#answerData[a]["answer"]#
																</cfif>
															</td>
														</tr>
													</cfloop>
												</table>
											</td>
										</tr>
									</table>
								</td>
								<td class="col21w col300h">&nbsp;</td>
								<td class="col452w col300h">
									<table border="0" cellpadding="0" cellspacing="0">
										<tr>
											<td class="col300w col300h"><div id="q12DonutChart" class="svgDonutChart"></div></td>
											<td class="col152w col300h">
												<!--- legend --->
												<cfset answerData = currentData[12].answers />
												<table border="0" cellpadding="0" cellspacing="0" class="legendTable">
													<cfloop index="a" from="1" to="#ArrayLen(answerData)#">
														<tr valign="top">
															<td style="color: #colors[a]#;"><i class="icon-stop"></i></td>
															<td align="left" width="100%">
																<cfif answerData[a]["answer"] eq "yes" or answerData[a]["answer"] eq true>
																	Yes
																<cfelseif answerData[a]["answer"] eq "no" or answerData[a]["answer"] eq false>
																	No
																<cfelse>
																	#answerData[a]["answer"]#
																</cfif>
															</td>
														</tr>
													</cfloop>
												</table>
											</td>
										</tr>
									</table>
								</td>
							</tr>
							<tr>
								<td colspan="3"><hr /></td>
							</tr>
							<tr>
								<td class="col452w col40h statHeader">PARENT EDUCATION LEVEL</td>
								<td class="col21w">&nbsp;</td>
								<td class="col452w col40h statHeader">ATTENDED with PARENTS</td>
							</tr>
							<tr valign="top">
								<td class="col452w col300h">
									<table border="0" cellpadding="0" cellspacing="0">
										<tr>
											<td class="col300w col300h"><div id="q6DonutChart" class="svgDonutChart"></div></td>
											<td class="col152w col300h">
												<!--- legend --->
												<cfset answerData = currentData[6].answers />
												<table border="0" cellpadding="0" cellspacing="0" class="legendTable">
													<cfloop index="a" from="1" to="#ArrayLen(answerData)#">
														<tr valign="top">
															<td style="color: #colors[a]#;"><i class="icon-stop"></i></td>
															<td width="100%">
																<cfif answerData[a]["answer"] eq "yes" or answerData[a]["answer"] eq true>
																	Yes
																<cfelseif answerData[a]["answer"] eq "no" or answerData[a]["answer"] eq false>
																	No
																<cfelse>
																	#answerData[a]["answer"]#
																</cfif>
															</td>
														</tr>
													</cfloop>
												</table>
											</td>
										</tr>
									</table>
								</td>
								<td class="col21w col300h">&nbsp;</td>
								<td class="col452w col300h">
									<table border="0" cellpadding="0" cellspacing="0">
										<tr>
											<td class="col300w col300h"><div id="q10DonutChart" class="svgDonutChart"></div></td>
											<td class="col152w col300h">
												<!--- legend --->
												<cfset answerData = currentData[10].answers />
												<table border="0" cellpadding="0" cellspacing="0" class="legendTable">
													<cfloop index="a" from="1" to="#ArrayLen(answerData)#">
														<tr valign="top">
															<td style="color: #colors[a]#;"><i class="icon-stop"></i></td>
															<td width="100%">
																<cfif answerData[a]["answer"] eq "yes" or answerData[a]["answer"] eq true>
																	Yes
																<cfelseif answerData[a]["answer"] eq "no" or answerData[a]["answer"] eq false>
																	No
																<cfelse>
																	#answerData[a]["answer"]#
																</cfif>
															</td>
														</tr>
													</cfloop>
												</table>
											</td>
										</tr>
									</table>
								</td>
							</tr>
						</table>
					</td>
				</tr>
				<tr>
					<td class="navCol" valign="bottom">
						<div class="mission">Cash for College is California's<br>public-private partnership FAFSA/CA Dream Act completion program administered by the California Student Aid Commission and its regional and local partners</div>
					</td>
				</tr>
			</table>
		</div>
	<cfelse>
		<!--- trend --->
		<div class="printPage">
			<table class="main" border="0" cellpadding="0" cellspacing="0">
				<tr valign="top">
					<td class="navCol" valign="top">
						<table class="nav" border="0" cellpadding="0" cellspacing="0">
							<tr valign="top">
								<td class="navHeader" align="center">
									<table border="0" cellpadding="0" cellspacing="0" style="border-spacing: 0px;">
										<tr>
											<td class="logo" align="center"><img src="/assets/calgrants/ui/images/hdwd/cash-for-college-logo_hires.png" /></td>
										<tr>
											<td class="logoText" align="center">
												<img src="/assets/calgrants/ui/images/hdwd/how-did-we-do-cropped.png" />
												<div class="logoYearText">IN&nbsp;#ListLast(Program_Year, "-")#</div>
											</td>
										</tr>
									</table>
								</td>
							</tr>
							<tr valign="top">
								<td class="navBody">
									<cfif IsDefined("site")>
										<div class="sideLabel greyDark">Site Name</div>
										<div class="sideText white">#site#</div>
									</cfif>
									<cfif IsDefined("siteType")>
										<div class="sideLabel greyDark">Site Type</div>
										<div class="sideText white">#siteType#</div>
									</cfif>
									<cfif IsDefined("siteSince")>
										<div class="sideLabel greyDark">Site Since</div>
										<div class="sideText white">#siteSince#</div>
									</cfif>
									<cfif IsDefined("city")>
										<div class="sideLabel greyDark">City</div>
										<div class="sideText white">#city#</div>
									</cfif>
									<cfif IsDefined("county")>
										<div class="sideLabel greyDark">County</div>
										<div class="sideText white">#county#</div>
									</cfif>
									<cfif IsDefined("region")>
										<div class="sideLabel greyDark">Region</div>
										<div class="sideText white">#region#</div>
									</cfif>
									<cfif IsDefined("workshopDate")>
										<div class="sideLabel greyDark">Workshop Date</div>
										<div class="sideText white">#DateFormat(workshopDate, "mmmm d, yyyy")#</div>
									</cfif>
									<cfif IsDefined("computerBasedWorkshop")>
										<div class="sideLabel greyDark">Computer Based Workshop</div>
										<div class="sideText white">#YesNoFormat(computerBasedWorkshop)#</div>
									</cfif>
									<cfif IsDefined("organization")>
											<div class="sideLabel greyDark"><cfif Workshop_ID gt 0 or Site_ID gt 0>Lead </cfif>Organization</div>
											<div class="sideText white">#organization#</div>
									</cfif>
									<cfif IsDefined("organizationSince")>
										<div class="sideLabel greyDark">Organization Since</div>
										<div class="sideText white">#organizationSince#</div>
									</cfif>
									<div class="sideLabel greyDark">Total Attendees</div>
									<div class="sideText white">#NumberFormat(baseResponses)#</div>
									<div class="sideLabel greyDark">Senior Attendees</div>
									<div class="sideText white">#NumberFormat(seniorBaseResponses)# (#Int(seniorBaseResponsePercent)#%)</div>
									<cfif IsDefined("followUpRequests") and IsDefined("followUpRequestsPct")>
										<div class="sideLabel greyDark">Follow-Up Requests</div>
										<div class="sideText white">#followUpRequests# (#Int(followUpRequestsPct)#%)</div>
									</cfif>
									<cfif IsDefined("followedUp")>
										<div class="sideLabel greyDark">Used Follow-Up Platform?</div>
										<div class="sideText white"><cfif followedUp gt 0>Yes (#followedUp#)<cfelse>No</cfif></div>
									</cfif>
									<cfif scholarshipCounts.RecordCount gt 0>
										<cfif Workshop_ID gt 0>
											<div class="sideLabel greyDark">Cash for College Scholarship Awarded?</div>
											<div class="sideText white">Yes</div>
										<cfelse>
											<div class="sideLabel greyDark">Scholarships Awarded</div>
											<div class="sideText white">Yes</div>
										</cfif>
									</cfif>
								</td>
							</tr>
						</table>
					</td>
					<td class="bodyCol" align="center" rowspan="2">
						<table border="0" cellpadding="0" cellspacing="0">
							<tr>
								<td class="col452w col40h statHeader">FAFSA/DREAM ACT APPLICATIONS</td>
								<td class="col21w col40h">&nbsp;</td>
								<td class="col452w col40h statHeader">CAL GRANT APPLICATIONS</td>
							</tr>
							<tr valign="top">
								<td class="col452w col215h">
									<table border="0" cellpadding="0" cellspacing="0">
										<tr>
											<td class="col362w">
												<!--- gingerbread --->
												<table id="fafsaCounts" border="0" cellpadding="0" cellspacing="2" class="gingerbreadTable">
													<tr class="gingerbreadTopRow">
														<cfif gdsData.fafsaCountLeadingCols gt 0>
															<td colspan="#gdsData.fafsaCountLeadingCols#">&nbsp;</td>
														</cfif>
														<td class="blueMarkerDown">#NumberFormat(gdsData.fafsaCompleted)#<br /><i class="icon-caret-down icon-3x blue"></i></td>
														<cfif gdsData.fafsaCountTrailingCols gt 0>
															<td colspan="#gdsData.fafsaCountTrailingCols#">&nbsp;</td>
														</cfif>
													</tr>
													<tr class="gingerbreadUpperRow">
														<cfset gender = "female">
														<cfloop index="i" from="1" to="#gdsData.fafsaCompletedGingerbreadCount#">
															<td class="#gender#Blue"></td>
															<cfif gender eq "female">
																<cfset gender = "male" />
															<cfelse>
																<cfset gender = "female">
															</cfif>
														</cfloop>
														<cfloop index="i" from="1" to="#gdsData.fafsaSubmittedGingerbreadCount#">
															<td class="#gender#Default"></td>
															<cfif gender eq "female">
																<cfset gender = "male" />
															<cfelse>
																<cfset gender = "female">
															</cfif>
														</cfloop>
													</tr>
													<tr class="gingerbreadBottomRow">
														<td colspan="9"></td>
														<td class="defaultMarkerUp"><i class="icon-caret-up icon-3x aqua"></i><br />#NumberFormat(gdsData.fafsaSubmitted)#</td>
													</tr>
												</table>
											</td>
											<td class="col90w" align="right">
												<!--- teardrops --->
												<table id="fafsaPercentages" border="0" cellpadding="0" cellspacing="1">
													<tr class="teardropHalfSmall">
														<td></td>
													</tr>
													<tr class="teardropSmall">
														<td valign="middle" align="center" class="aquaTeardropNWSmall"><span class="upsize150">#gdsData.fafsaSubmittedPercent#%</span><br />Submitted</td>
													</tr>
													<tr class="teardropSmall">
														<td valign="middle" align="center" class="blueTeardropNESmall"><span class="upsize150">#gdsData.fafsaCompletedPercent#%</span><br />Complete</td>
													</tr>
													<tr class="teardropHalfSmall">
														<td></td>
													</tr>
												</table>
											</td>
										</tr>
									</table>
								</td>
								<td class="col21w col215h">&nbsp;</td>
								<td class="col452w col215h">
									<table border="0" cellpadding="0" cellspacing="0">
										<tr>
											<td class="col362w">
												<!--- gingerbread --->
												<table id="calgrantCounts" border="0" cellpadding="0" cellspacing="2" class="gingerbreadTable">
													<tr class="gingerbreadTopRow">
														<cfif gdsData.calgrantCountLeadingColsTop gt 0>
															<td colspan="#gdsData.calgrantCountLeadingColsTop#">&nbsp;</td>
														</cfif>
														<td class="blueMarkerDown">#NumberFormat(gdsData.calgrantCompleted)#<br /><i class="icon-caret-down icon-3x blue"></i></td>									
														<cfif gdsData.calgrantCountTrailingColsTop gt 0>
															<td colspan="#gdsData.calgrantCountTrailingColsTop#">&nbsp;</td>
														</cfif>
													</tr>
													<tr class="gingerbreadUpperRow">
														<cfset gender = "female">
														<cfloop index="i" from="1" to="#gdsData.calgrantAwardedGingerbreadCount#">
															<td class="#gender#Green"></td>
															<cfif gender eq "female">
																<cfset gender = "male" />
															<cfelse>
																<cfset gender = "female">
															</cfif>
														</cfloop>
														<cfloop index="i" from="1" to="#gdsData.calgrantCompletedGingerbreadCount#">
															<td class="#gender#Blue"></td>
															<cfif gender eq "female">
																<cfset gender = "male" />
															<cfelse>
																<cfset gender = "female">
															</cfif>
														</cfloop>
														<cfloop index="i" from="1" to="#gdsData.calgrantSubmittedGingerbreadCount#">
															<td class="#gender#Default"></td>
															<cfif gender eq "female">
																<cfset gender = "male" />
															<cfelse>
																<cfset gender = "female">
															</cfif>
														</cfloop>
													</tr>
													<tr class="gingerbreadBottomRow">
														<cfif gdsData.calgrantCountLeadingColsBottom gt 0>
															<td colspan="#gdsData.calgrantCountLeadingColsBottom#">&nbsp;</td>
														</cfif>
														<td class="greenMarkerUp"><i class="icon-caret-up icon-3x green"></i><br />#NumberFormat(gdsData.calgrantAwarded)#</td>	
														<cfif gdsData.calgrantCountTrailingColsBottom gt 0>
															<td colspan="#gdsData.calgrantCountTrailingColsBottom#">&nbsp;</td>
														</cfif>
														<cfif gdsData.calgrantAwarded neq gdsData.calgrantSubmitted>
															<td class="defaultMarkerUp"><i class="icon-caret-up icon-3x aqua"></i><br />#NumberFormat(gdsData.calgrantSubmitted)#</td>
														</cfif>
													</tr>
												</table>
											</td>
											<td class="col90w" align="right">
												<!--- teardrops --->
												<table id="calgrantPercentages" border="0" cellpadding="0" cellspacing="1">
													<tr class="teardropSmall">
														<td valign="middle" align="center" class="aquaTeardropNWSmall"><span class="upsize150">#gdsData.calgrantSubmittedPercent#%</span><br />Submitted</td>
													</tr>
													<tr class="teardropSmall">
														<td valign="middle" align="center" class="blueTeardropNESmall"><span class="upsize150">#gdsData.calgrantCompletedPercent#%</span><br />Complete</td>
													</tr>
													<tr class="teardropSmall">
														<td valign="middle" align="center" class="greenTeardropNESmall"><span class="upsize150">#gdsData.calgrantAwardedPercent#%</span><br />Offered</td>
													</tr>
												</table>
											</td>
										</tr>
									</table>
								</td>
							</tr>
							<tr valign="top">
								<td class="col452w col80h">
									<!--- arrow --->
									<table border="0" cellpadding="0" cellspacing="0" width="100%">
										<tr class="dollarArrow">
											<td class="arrow">
												<img src="/assets/calgrants/ui/images/hdwd/pell-grant-arrow.png">
											</td>
											<td class="dollarAward" nowrap="nowrap" width="100%">$#NumberFormat(gdsData.fafsaDollarsAwarded)#</td>
										</tr>
									</table>
								</td>
								<td class="col21w col80h">&nbsp;</td>
								<td class="col452w col80h">
									<!--- arrow --->
									<table border="0" cellpadding="0" cellspacing="0" width="100%">
										<tr class="dollarArrow">
											<td class="arrow">
												<img src="/assets/calgrants/ui/images/hdwd/cal-grant-arrow.png">
											</td>
											<td class="dollarAward" nowrap="nowrap" width="100%">$#NumberFormat(gdsData.calgrantDollarsAwarded)#</td>
										</tr>
									</table>
								</td>
							</tr>
							<tr>
								<td colspan="3"><hr /></td>
							</tr>
							<tr>
								<td class="col452w col40h statHeader">WORKSHOP RATING</td>
								<td class="col21w col40h">&nbsp;</td>
								<td class="col452w col40h trendChartLabel">#ListLast(ListFirst(programYears, ","), "-")#-#ListLast(ListLast(programYears, ","), "-")# Trend<!--- <cfif IsDefined("site")> for #site# Site</cfif> ---></td>
							</tr>
							<tr valign="middle">
								<td class="col452w col274h">
									<!--- rating --->
									<table id="workshopRating" border="0" cellpadding="0" cellspacing="0">
										<tr class="ratingPercentRow">
											<td class="ratingPercent blue" width="25%">#Int(currentData[1].answers[1].response_percent)#<span class="ratingPercentSymbol">%</span></td>
											<td class="ratingPercent green" width="25%">#Int(currentData[1].answers[2].response_percent)#<span class="ratingPercentSymbol">%</span></td>
											<td class="ratingPercent blueDark" width="25%">#Int(currentData[1].answers[3].response_percent)#<span class="ratingPercentSymbol">%</span></td>
											<td class="ratingPercent aqua" width="25%">#Int(currentData[1].answers[4].response_percent)#<span class="ratingPercentSymbol">%</span></td>
										</tr>
										<tr class="ratingPercentLabelRow">
											<td>Excellent</td>
											<td>Good</td>
											<td>Fair</td>
											<td>Poor</td>
										</tr>
									</table>
								</td>
								<td class="col21w col274h">&nbsp;</td>
								<td class="col452w col274h"><div id="q1TrendLineChart" class="svgTrendLineChart"></div></td>
							</tr>
							<tr>
								<td colspan="3"><hr /></td>
							</tr>
							<tr>
								<td class="col452w col40h statHeader">ATTENDANCE by GENDER</td>
								<td class="col21w col40h">&nbsp;</td>
								<td class="col452w col40h trendChartLabel">#ListLast(ListFirst(programYears, ","), "-")#-#ListLast(ListLast(programYears, ","), "-")# Trend<!--- <cfif IsDefined("site")> for #site# Site</cfif> ---></td>
							</tr>
							<tr valign="middle">
								<td class="col452w col274h">
									<table border="0" cellpadding="0" cellspacing="0">
										<tr>
											<td class="col362w">
												<!--- gingerbread --->
												<table id="genderCounts" border="0" cellpadding="0" cellspacing="2" class="gingerbreadTable" width="100%">
													<tr class="gingerbreadTopRow">
														<cfif genderData.femaleCountLeadingCols gt 0>
															<td colspan="#genderData.femaleCountLeadingCols#">&nbsp;</td>
														</cfif>
														<td class="greenMarkerDown">#NumberFormat(genderData.femaleCount)#<br /><i class="icon-caret-down icon-3x green"></i></td>
														<cfif genderData.femaleCountTrailingCols gt 1>
															<td colspan="#genderData.femaleCountTrailingCols#">&nbsp;</td>
														</cfif>
													</tr>
													<tr class="gingerbreadUpperRow">
														<cfloop index="i" from="1" to="#genderData.femaleOnCount#">
															<td class="femaleGreen"></td>
														</cfloop>
														<cfloop index="i" from="1" to="#genderData.femaleOffCount#">
															<td class="femaleDefault"></td>
														</cfloop>
													</tr>
													<tr class="gingerbreadLowerRow">
														<cfloop index="i" from="1" to="#genderData.maleOnCount#">
															<td class="maleBlue"></td>
														</cfloop>
														<cfloop index="i" from="1" to="#genderData.maleOffCount#">
															<td class="maleDefault"></td>
														</cfloop>
													</tr>
													<tr class="gingerbreadBottomRow">
														<cfif genderData.maleCountLeadingCols gt 0>
															<td colspan="#genderData.maleCountLeadingCols#">&nbsp;</td>
														</cfif>
														<td class="blueMarkerUp"><i class="icon-caret-up icon-3x blue"></i><br />#NumberFormat(genderData.maleCount)#</td>
														<cfif genderData.maleCountTrailingCols gt 0>
															<td colspan="#genderData.maleCountTrailingCols#">&nbsp;</td>
														</cfif>
														<td class="defaultMarkerUp"><i class="icon-caret-up icon-3x aqua"></i><br />#NumberFormat(genderData.maleFemaleCount)#</td>
													</tr>
												</table>
											</td>
											<td class="col90w" align="right">
												<!--- tearpanels --->
												<table id="genderPercentages" border="0" cellpadding="0" cellspacing="1">
													<tr class="tearpanel">
														<td valign="top" class="femaleTearpanel">#Int(genderData.femalePercent)#%</td>
														<td valign="bottom" class="maleTearpanel">#Int(genderData.malePercent)#%</td>
													</tr>
												</table>
											</td>
										</tr>
									</table>
								</td>
								<td class="col21w col274h">&nbsp;</td>
								<td class="col452w col274h"><div id="q11TrendLineChart" class="svgTrendLineChart"></div></td>
							</tr>
							<tr>
								<td colspan="3"><hr /></td>
							</tr>
							<tr>
								<td class="col452w col40h statHeader">SENIOR ATTENDANCE</td>
								<td class="col21w col40h">&nbsp;</td>
								<td class="col452w col40h trendChartLabel">#ListLast(ListFirst(programYears, ","), "-")#-#ListLast(ListLast(programYears, ","), "-")# Trend<!--- <cfif IsDefined("site")> for #site# Site</cfif> ---></td>
							</tr>
							<tr valign="top">
								<td class="col452w col300h">
									<table border="0" cellpadding="0" cellspacing="0">
										<tr>
											<td class="col300w col300h"><div id="q7DonutChart" class="svgDonutChart"></div></td>
											<td class="col152w col300h">
												<!--- legend --->
												<cfset answerData = currentData[7].answers />
												<table border="0" cellpadding="0" cellspacing="0" class="legendTable">
													<cfloop index="a" from="1" to="#ArrayLen(answerData)#">
														<tr valign="top">
															<td style="color: #colors[a]#;"><i class="icon-stop"></i></td>
															<td align="left" width="100%">
																<cfif answerData[a]["answer"] eq "yes" or answerData[a]["answer"] eq true>
																	Yes
																<cfelseif answerData[a]["answer"] eq "no" or answerData[a]["answer"] eq false>
																	No
																<cfelse>
																	#answerData[a]["answer"]#
																</cfif>
															</td>
														</tr>
													</cfloop>
												</table>
											</td>
										</tr>
									</table>
								</td>
								<td class="col21w col300h">&nbsp;</td>
								<td class="col452w col300h"><div id="q7TrendAreaChart" class="svgTrendAreaChart"></div></td>
							</tr>
						</table>
					</td>
				</tr>
				<tr>
					<td class="navCol" valign="bottom">
						<div class="mission">Cash for College is California's<br>public-private partnership FAFSA/CA Dream Act completion program administered by the California Student Aid Commission and its regional and local partners</div>
					</td>
				</tr>
			</table>
		</div>
		<div class="printPage">
			<table class="main" border="0" cellpadding="0" cellspacing="0">
				<tr valign="top">
					<td class="navCol">&nbsp;</td>
					<td class="bodyCol" align="center">
					
						<table border="0" cellpadding="0" cellspacing="0">
							<tr>
								<td class="col452w col40h statHeader">ATTENDANCE by RACE/ETHNICITY</td>
								<td class="col21w col40h">&nbsp;</td>
								<td class="col452w col40h trendChartLabel">#ListLast(ListFirst(programYears, ","), "-")#-#ListLast(ListLast(programYears, ","), "-")# Trend<!--- <cfif IsDefined("site")> for #site# Site</cfif> ---></td>
							</tr>
							<tr valign="top">
								<td class="col452w col300h">
									<table border="0" cellpadding="0" cellspacing="0">
										<tr>
											<td class="col300w col300h"><div id="q12DonutChart" class="svgDonutChart"></div></td>
											<td class="col152w col300h">
												<!--- legend --->
												<cfset answerData = currentData[12].answers />
												<table border="0" cellpadding="0" cellspacing="0" class="legendTable">
													<cfloop index="a" from="1" to="#ArrayLen(answerData)#">
														<tr valign="top">
															<td style="color: #colors[a]#;"><i class="icon-stop"></i></td>
															<td align="left" width="100%">
																<cfif answerData[a]["answer"] eq "yes" or answerData[a]["answer"] eq true>
																	Yes
																<cfelseif answerData[a]["answer"] eq "no" or answerData[a]["answer"] eq false>
																	No
																<cfelse>
																	#answerData[a]["answer"]#
																</cfif>
															</td>
														</tr>
													</cfloop>
												</table>
											</td>
										</tr>
									</table>
								</td>
								<td class="col21w col300h">&nbsp;</td>
								<td class="col452w col300h"><div id="q12TrendLineChart" class="svgTrendLineChart"></div></td>
							</tr>
							<tr>
								<td colspan="3"><hr /></td>
							</tr>
							<tr>
								<td class="col452w col40h statHeader">PARENT EDUCATION LEVEL</td>
								<td class="col21w">&nbsp;</td>
								<td class="col452w col40h trendChartLabel">#ListLast(ListFirst(programYears, ","), "-")#-#ListLast(ListLast(programYears, ","), "-")# Trend<!--- <cfif IsDefined("site")> for #site# Site</cfif> ---></td>
							</tr>
							<tr valign="top">
								<td class="col452w col300h">
									<table border="0" cellpadding="0" cellspacing="0">
										<tr>
											<td class="col300w col300h"><div id="q6DonutChart" class="svgDonutChart"></div></td>
											<td class="col152w col300h">
												<!--- legend --->
												<cfset answerData = currentData[6].answers />
												<table border="0" cellpadding="0" cellspacing="0" class="legendTable">
													<cfloop index="a" from="1" to="#ArrayLen(answerData)#">
														<tr valign="top">
															<td style="color: #colors[a]#;"><i class="icon-stop"></i></td>
															<td width="100%">
																<cfif answerData[a]["answer"] eq "yes" or answerData[a]["answer"] eq true>
																	Yes
																<cfelseif answerData[a]["answer"] eq "no" or answerData[a]["answer"] eq false>
																	No
																<cfelse>
																	#answerData[a]["answer"]#
																</cfif>
															</td>
														</tr>
													</cfloop>
												</table>
											</td>
										</tr>
									</table>
								</td>
								<td class="col21w col300h">&nbsp;</td>
								<td class="col452w col300h"><div id="q6TrendLineChart" class="svgTrendLineChart"></div></td>
							</tr>
							<tr>
								<td colspan="3"><hr /></td>
							</tr>
							<tr>
								<td class="col452w col40h statHeader">ATTENDED with PARENTS</td>
								<td class="col21w">&nbsp;</td>
								<td class="col452w col40h trendChartLabel">#ListLast(ListFirst(programYears, ","), "-")#-#ListLast(ListLast(programYears, ","), "-")# Trend<!--- <cfif IsDefined("site")> for #site# Site</cfif> ---></td>
							</tr>
							<tr valign="top">
								<td class="col452w col300h">
									<table border="0" cellpadding="0" cellspacing="0">
										<tr>
											<td class="col300w col300h"><div id="q10DonutChart" class="svgDonutChart"></div></td>
											<td class="col152w col300h">
												<!--- legend --->
												<cfset answerData = currentData[10].answers />
												<table border="0" cellpadding="0" cellspacing="0" class="legendTable">
													<cfloop index="a" from="1" to="#ArrayLen(answerData)#">
														<tr valign="top">
															<td style="color: #colors[a]#;"><i class="icon-stop"></i></td>
															<td width="100%">
																<cfif answerData[a]["answer"] eq "yes" or answerData[a]["answer"] eq true>
																	Yes
																<cfelseif answerData[a]["answer"] eq "no" or answerData[a]["answer"] eq false>
																	No
																<cfelse>
																	#answerData[a]["answer"]#
																</cfif>
															</td>
														</tr>
													</cfloop>
												</table>
											</td>
										</tr>
									</table>
								</td>
								<td class="col21w col300h">&nbsp;</td>
								<td class="col452w col300h"><div id="q10TrendLineChart" class="svgTrendLineChart"></div></td>
							</tr>
							<tr>
								<td colspan="3"><hr /></td>
							</tr>
						</table>
					
					</td>
				</tr>
			</table>
		</div>
	</cfif>
	<!--- Source of data --->
	<div class="printPage">
		<div class="main">
			<div class="sourceInfo">
				<h3 class="blueDark">SOURCE OF DATA</h3>
				<p>Each year California Cash for College collects participant exit surveys at the time of the workshop. How Did We Do summaries aggregate distinct participant exit surveys to create online reports. Participant FAFSA, California Dream Act Application and Cal Grant Application data was extracted from the California Student Aid Commission Grant Delivery System (GDS) in late August #ListLast(Program_Year, "-")#.</p>
				<hr />
				<table border="0" cellpadding="0" cellspacing="0">
					<tr valign="top">
						<td width="49%">
							<h3 class="blue">FAFSA/DREAM ACT APPLICATIONS</h3>
							
							<p>The Free Application for Federal Student Aid (FAFSA) and the CA Dream Act Application are gateway applications for grant financial aid in California. Application counts are grouped together.</p>
							
							<p><strong>SUBMITTED/COMPLETED FAFSAs & CA Dream Act Applications</strong></p>
							
							<p><strong>Submitted:</strong> Aggregate count of FAFSAs & CA Dream Act Applications submitted by workshop, organization, county, region, or state levels. Percentage is based on FAFSA/Dream Act Applications submitted from all Cash for College participants.</p>
							
							<p><strong>Completed:</strong> Aggregate count of FAFSAs & CA Dream Act Applications submitted AND that can be processed for financial aid. This means applications that have generated an Expected Family Contribution (EFC). Percentage is based on FAFSA/Dream Act Applications that have EFC, which means they can be processed for financial aid consideration.</p>
							
							<p><strong>Estimated Pell Grants:</strong> The federal government provides states Pell eligibility for each completed FAFSA. Using Pell eligibility for each qualifying applicant, and the most recently available average Pell Grant award of <cfif Program_Year eq "2012-2013">$3,685<cfelseif Program_Year eq "2013-2014">$3,650</cfif>, estimated Pell grant funding is displayed.</p>
						</td>
						<td width="2%"></td>
						<td width="49%">
							<h3 class="blue">CAL GRANT APPLICATIONS</h3>
							<p><strong>Submitted:</strong> Number of students who submitted a FAFSA or Dream Act Application and a Cal Grant GPA. Percentage is based on Cal Grant applications submitted from all workshop participants.</p>
							
							<p><strong>Completed:</strong> Students who submitted a complete FAFSA or Dream Act Application (one that has an EFC) and Cal Grant GPA by the March 2 deadline. Percentage is based on Cal Grant Applications that were complete and received by the deadline.</p>
							
							<p><strong>Offered:</strong> Number and percentage of applicants who were offered a Cal Grant Award.</p>
							
							<p><strong>Cal Grant Funding Offered:</strong> Using Commission Cal Grant award offer amounts, aggregated dollar amounts are displayed.</p>
						</td>
					</tr>
				</table>
				<hr />
				<table border="0" cellpadding="0" cellspacing="0">
					<tr valign="top">
						<td width="49%">
							<h3 class="blue">WORKSHOP RATING</h3>
							<p><strong>Source:</strong> #ListLast(Program_Year, "-")# California Cash for College Exit Survey.</p>   
						</td>
						<td width="2%"></td>
						<td width="49%">
							<h3 class="blue">ATTENDANCE by GENDER</h3>
							<p>Percentages may not add up to 100 because students may have skipped the question, or answered declined to state.</p>
							
							<p><strong>Source:</strong> #ListLast(Program_Year, "-")# California Cash for College Exit Survey.</p> 
						</td>
					</tr>
				</table>
				<hr />
				<table border="0" cellpadding="0" cellspacing="0">
					<tr valign="top">
						<td width="49%">
							<h3 class="blue">SENIOR ATTENDANCE</h3>
							<p>Percentages may not add up to 100 because students may have skipped the question.</p>
							
							<p><strong>Source:</strong> #ListLast(Program_Year, "-")# California Cash for College Exit Survey.</p> 
						</td>
						<td width="2%"></td>
						<td width="49%">
							<h3 class="blue">ATTENDANCE by RACE/ETHNICITY</h3>
							<p>Percentages may exceed 100 percent as students may have marked more than one race/ethnicity.</p>
			
							<p><strong>Source:</strong> #ListLast(Program_Year, "-")# California Cash for College Exit Survey.</p> 
						</td>
					</tr>
				</table>
				<hr />
				<table border="0" cellpadding="0" cellspacing="0">
					<tr valign="top">
						<td width="49%">
							<h3 class="blue">PARENT EDUCATION LEVEL</h3>
							<p><strong>Source:</strong> #ListLast(Program_Year, "-")# California Cash for College Exit Survey.</p> 
						</td>
						<td width="2%"></td>
						<td width="49%">
							<h3 class="blue">ATTENDED with PARENTS</h3>
							<p>The definition of "Parents" includes guardians. The question is phrased: Did you attend with your parent/ guardian?</p>
							
							<p><strong>Source:</strong> #ListLast(Program_Year, "-")# California Cash for College Exit Survey.</p> 
						</td>
					</tr>
				</table>
				<cfif Workshop_ID gt 0>
					<hr />
					<table border="0" cellpadding="0" cellspacing="0">
						<tr valign="top">
							<td>
								<h3 class="blue">OTHER CATEGORIES</h3>
								<p><strong>Computer based workshop:</strong> Workshop offered access to computers to offer students direct access to application completion.</p>
								
								<p><strong>Lead Organization:</strong> Cash for College involves multiple partners. The Lead Organization registers the workshop and takes a primary role in managing logistics for the workshop.</p>
								
								<p><strong>Organization Since:</strong> Cash for College workshops have been offered since 2003. Cash for College began matching participant data to the Commission's GDS in 2005. This data engine uses data beginning in 2009.</p>
								
								<p><strong>Follow Up Requests/Used Follow Up Platform:</strong> Each year, across all workshops statewide, about a third of students request some form of follow up assistance. Offering Follow Up assistance is part of the Cash for College model. In 2013 Cash for College launched a Student Follow Up tracking feature to assist students after the workshop to meet the March 2 deadline.</p>
								
								<p><strong>Scholarship Awarded:</strong> Since 2005, Cash for College has offered incentive scholarships for qualifying workshops to help students maximize their financial aid by applying for a Cal Grant.</p>
							</td>
						</tr>
					</table>
				</cfif>
			</div>
		</div>
	</div>
</cfoutput>
</body>
</html>
<cfsetting showdebugoutput="no">